QUERY PLAN                                                         
                 
--------------------------------------------------------------------------------------------------------------------------------------------
-----------------
 Limit  (cost=9090.60..9090.65 rows=20 width=166) (actual time=441.619..441.674 rows=20 loops=1)
   ->  Sort  (cost=9089.85..9106.26 rows=6567 width=166) (actual time=441.062..441.362 rows=320 loops=1)
         Sort Key: tcf.fech_hora
         Sort Method:  top-N heapsort  Memory: 118kB
         ->  Hash Join  (cost=6660.18..8783.76 rows=6567 width=166) (actual time=310.561..427.393 rows=6511 loops=1)
               Hash Cond: (tcsc.id_soli_compra = tcf.id_soli_compra)
               ->  Hash Join  (cost=5600.47..7551.97 rows=6548 width=158) (actual time=281.279..378.434 rows=6544 loops=1)
                     Hash Cond: (tcsc.esta_solicitud = tgdc.seq_det_cat)
                     ->  Hash Join  (cost=5577.86..7439.33 rows=6548 width=147) (actual time=279.590..361.704 rows=6545 loops=1)
                           Hash Cond: ((tcsc.persona_id)::numeric = tgp.persona_id)
                           ->  Seq Scan on tcom_solicitud_compra tcsc  (cost=0.00..799.77 rows=6548 width=125) (actual time=0.013..18.433 ro
ws=6545 loops=1)
                                 Filter: ((esta_solicitud <> 425) AND (esta_solicitud <> 424) AND (esta_solicitud <> 416))
                           ->  Hash  (cost=3878.94..3878.94 rows=83594 width=34) (actual time=278.837..278.837 rows=83594 loops=1)
                                 ->  Seq Scan on tgen_persona tgp  (cost=0.00..3878.94 rows=83594 width=34) (actual time=0.006..136.582 rows
=83594 loops=1)
                     ->  Hash  (cost=14.49..14.49 rows=649 width=15) (actual time=1.657..1.657 rows=649 loops=1)
                           ->  Seq Scan on tgen_det_cat tgdc  (cost=0.00..14.49 rows=649 width=15) (actual time=0.008..0.803 rows=649 loops=
1)
               ->  Hash  (cost=977.62..977.62 rows=6567 width=16) (actual time=29.264..29.264 rows=6556 loops=1)
                     ->  Seq Scan on tcom_fecha tcf  (cost=0.00..977.62 rows=6567 width=16) (actual time=0.016..20.532 rows=6556 loops=1)
                           Filter: (seq_det_cat = 388)
 Total runtime: 443.434 ms
(20 rows)