explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PCQv

Settings
# exclusive inclusive rows x rows loops node
1. 10.207 453.064 ↓ 13.6 17,761 1

Sort (cost=132,926.98..132,930.25 rows=1,307 width=304) (actual time=451.941..453.064 rows=17,761 loops=1)

  • Sort Key: cc.created_dt
  • Sort Method: quicksort Memory: 5512kB
2. 22.534 442.857 ↓ 13.6 17,761 1

WindowAgg (cost=132,810.32..132,859.33 rows=1,307 width=304) (actual time=418.803..442.857 rows=17,761 loops=1)

3. 62.817 420.323 ↓ 13.6 17,761 1

Sort (cost=132,810.32..132,813.59 rows=1,307 width=134) (actual time=418.782..420.323 rows=17,761 loops=1)

  • Sort Key: cc.transaction_amt, cc.state, cfm.cmte_nm, cc.transaction_dt, cc.name, cc.transaction_pgi, cc.city, cc.zip_code
  • Sort Method: quicksort Memory: 4041kB
4. 15.153 357.506 ↓ 13.6 17,761 1

Nested Loop Left Join (cost=1.15..132,742.67 rows=1,307 width=134) (actual time=4.554..357.506 rows=17,761 loops=1)

5. 21.201 324.592 ↓ 13.6 17,761 1

Nested Loop Left Join (cost=0.87..132,327.07 rows=1,307 width=126) (actual time=4.550..324.592 rows=17,761 loops=1)

6. 6.254 214.586 ↓ 13.6 17,761 1

Nested Loop (cost=0.58..131,925.16 rows=1,307 width=90) (actual time=4.425..214.586 rows=17,761 loops=1)

7. 0.082 0.082 ↓ 1.2 119 1

Function Scan on json_array_elements v1 (cost=0.00..1.00 rows=100 width=32) (actual time=0.056..0.082 rows=119 loops=1)

8. 208.250 208.250 ↓ 8.8 149 119

Index Scan using ix_contributions_fec_contributions_name_state_lw on contributions_fec_contributions cc (cost=0.57..1,319.07 rows=17 width=90) (actual time=0.507..1.750 rows=149 loops=119)

  • Index Cond: (lower((name)::text) = lower((v1.value ->> 0)))
  • Filter: (((transaction_tp IS NULL) OR ((transaction_tp)::text <> '24T'::text)) AND (transaction_dt >= '1900-01-01'::date) AND (transaction_dt <= '2020-01-01'::date) AND ((state IS NULL) OR (lower((state)::text) = lower((v1.value ->> 1)))))
  • Rows Removed by Filter: 573
9. 88.805 88.805 ↑ 1.0 1 17,761

Index Scan using contributions_fec_committees_pkey on contributions_fec_committees cfm (cost=0.29..0.31 rows=1 width=55) (actual time=0.005..0.005 rows=1 loops=17,761)

  • Index Cond: ((cc.cmte_id)::text = (cmte_id)::text)
10. 17.761 17.761 ↓ 0.0 0 17,761

Index Scan using contributions_fec_candidates_pkey on contributions_fec_candidates cfc (cost=0.29..0.32 rows=1 width=27) (actual time=0.001..0.001 rows=0 loops=17,761)

  • Index Cond: ((cfm.cand_id)::text = (cand_id)::text)
Planning time : 3.198 ms
Execution time : 456.923 ms