explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ycEa

Settings
# exclusive inclusive rows x rows loops node
1. 0.349 117.956 ↑ 6.9 190 1

Unique (cost=137,699.90..137,782.28 rows=1,318 width=346) (actual time=116.422..117.956 rows=190 loops=1)

2. 1.159 117.607 ↑ 1.8 738 1

WindowAgg (cost=137,699.90..137,755.92 rows=1,318 width=346) (actual time=116.420..117.607 rows=738 loops=1)

3. 1.975 116.418 ↑ 1.8 738 1

Sort (cost=137,693.86..137,697.15 rows=1,318 width=148) (actual time=116.367..116.418 rows=738 loops=1)

  • Sort Key: cc.transaction_amt, cc.state, cc.cmte_nm, cc.transaction_dt, cc.name, cc.transaction_pgi, cc.city, cc.zip_code
  • Sort Method: quicksort Memory: 216kB
4. 0.331 114.443 ↑ 1.8 738 1

Subquery Scan on cc (cost=137,609.08..137,625.56 rows=1,318 width=148) (actual time=114.035..114.443 rows=738 loops=1)

5. 0.785 114.112 ↑ 1.8 738 1

Sort (cost=137,609.08..137,612.38 rows=1,318 width=12,876) (actual time=114.034..114.112 rows=738 loops=1)

  • Sort Key: cc_1.created_dt
  • Sort Method: quicksort Memory: 214kB
6. 1.533 113.327 ↑ 1.8 738 1

Nested Loop Left Join (cost=1.15..133,282.93 rows=1,318 width=12,876) (actual time=0.111..113.327 rows=738 loops=1)

7. 0.443 110.318 ↑ 1.8 738 1

Nested Loop Left Join (cost=0.87..132,863.84 rows=1,318 width=140) (actual time=0.091..110.318 rows=738 loops=1)

8. 0.479 104.709 ↑ 1.8 738 1

Nested Loop (cost=0.58..132,458.54 rows=1,318 width=104) (actual time=0.075..104.709 rows=738 loops=1)

9. 0.038 0.038 ↑ 2.3 44 1

Function Scan on json_array_elements v1 (cost=0.00..1.00 rows=100 width=32) (actual time=0.026..0.038 rows=44 loops=1)

10. 104.192 104.192 ↑ 1.1 17 44

Index Scan using ix_contributions_fec_contributions_name_state_lw on contributions_fec_contributions cc_1 (cost=0.57..1,324.40 rows=18 width=104) (actual time=0.859..2.368 rows=17 loops=44)

  • Index Cond: (lower((name)::text) = lower((v1.value ->> 0)))
  • Filter: (((transaction_tp IS NULL) OR ((transaction_tp)::text <> '24T'::text)) AND ((state IS NULL) OR (lower((state)::text) = lower((v1.value ->> 1)))))
  • Rows Removed by Filter: 776
11. 5.166 5.166 ↑ 1.0 1 738

Index Scan using contributions_fec_committees_pkey on contributions_fec_committees cfm (cost=0.29..0.31 rows=1 width=55) (actual time=0.007..0.007 rows=1 loops=738)

  • Index Cond: ((cc_1.cmte_id)::text = (cmte_id)::text)
12. 1.476 1.476 ↓ 0.0 0 738

Index Scan using contributions_fec_candidates_pkey on contributions_fec_candidates cfc (cost=0.29..0.32 rows=1 width=27) (actual time=0.002..0.002 rows=0 loops=738)

  • Index Cond: ((cfm.cand_id)::text = (cand_id)::text)
13.          

SubPlan (forWindowAgg)

14. 0.002 0.012 ↓ 0.0 0 1

ProjectSet (cost=2.25..2.77 rows=100 width=8) (actual time=0.012..0.012 rows=0 loops=1)

15. 0.002 0.010 ↑ 1.0 1 1

Aggregate (cost=2.25..2.26 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=1)

16. 0.008 0.008 ↓ 0.0 0 1

Function Scan on json_array_elements (cost=0.00..1.00 rows=100 width=32) (actual time=0.008..0.008 rows=0 loops=1)

17. 0.004 0.018 ↑ 50.0 2 1

ProjectSet (cost=2.25..2.77 rows=100 width=8) (actual time=0.017..0.018 rows=2 loops=1)

18. 0.009 0.014 ↑ 1.0 1 1

Aggregate (cost=2.25..2.26 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=1)

19. 0.005 0.005 ↑ 50.0 2 1

Function Scan on json_array_elements json_array_elements_1 (cost=0.00..1.00 rows=100 width=32) (actual time=0.005..0.005 rows=2 loops=1)

Planning time : 2.120 ms
Execution time : 118.231 ms