explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UDX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 385,220.668 ↓ 0.0 0 1

Limit (cost=1.42..128,498.06 rows=30 width=2,139) (actual time=385,220.668..385,220.668 rows=0 loops=1)

2. 0.000 385,220.666 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.42..79,085,395.42 rows=18,464 width=2,139) (actual time=385,220.666..385,220.666 rows=0 loops=1)

3. 0.002 385,220.666 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.00..79,003,680.47 rows=18,464 width=1,814) (actual time=385,220.666..385,220.666 rows=0 loops=1)

4. 0.002 385,220.664 ↓ 0.0 0 1

Merge Append (cost=0.58..78,921,965.51 rows=18,464 width=1,489) (actual time=385,220.664..385,220.664 rows=0 loops=1)

  • Sort Key: fec_fitem_sched_a.contb_receipt_dt DESC, fec_fitem_sched_a.sub_id DESC
5. 0.006 0.015 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=5,691) (actual time=0.015..0.015 rows=0 loops=1)

  • Sort Key: fec_fitem_sched_a.contb_receipt_dt DESC, fec_fitem_sched_a.sub_id DESC
  • Sort Method: quicksort Memory: 25kB
6. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on fec_fitem_sched_a (cost=0.00..0.00 rows=1 width=5,691) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (is_individual AND (two_year_transaction_period = '2018'::numeric) AND ((contributor_name_text @@ to_tsquery('Vavic'::text)) OR (contributor_name_text @@ to_tsquery('Vandemoer'::text))))
7. 385,220.647 385,220.647 ↓ 0.0 0 1

Index Scan Backward using idx_sched_a_2017_2018_two_year_period_dt_sub_id on fec_fitem_sched_a_2017_2018 (cost=0.56..78,921,734.68 rows=18,463 width=1,489) (actual time=385,220.647..385,220.647 rows=0 loops=1)

  • Index Cond: (two_year_transaction_period = '2018'::numeric)
  • Filter: (is_individual AND ((contributor_name_text @@ to_tsquery('Vavic'::text)) OR (contributor_name_text @@ to_tsquery('Vandemoer'::text))))
  • Rows Removed by Filter: 88436963
8. 0.000 0.000 ↓ 0.0 0

Index Scan using ofec_committee_history_mv_tmp_cycle_committee_id_idx on ofec_committee_history_mv ofec_committee_history_mv_1 (cost=0.42..4.42 rows=1 width=325) (never executed)

  • Index Cond: ((fec_fitem_sched_a.two_year_transaction_period = cycle) AND (cycle = '2018'::numeric) AND ((fec_fitem_sched_a.cmte_id)::text = (committee_id)::text))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using ofec_committee_history_mv_tmp_cycle_committee_id_idx on ofec_committee_history_mv ofec_committee_history_mv_2 (cost=0.42..4.42 rows=1 width=325) (never executed)

  • Index Cond: ((fec_fitem_sched_a.two_year_transaction_period = cycle) AND (cycle = '2018'::numeric) AND ((fec_fitem_sched_a.clean_contbr_id)::text = (committee_id)::text))
Planning time : 28.286 ms
Execution time : 385,220.995 ms