explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eEBp

Settings
# exclusive inclusive rows x rows loops node
1. 21.268 405.422 ↓ 13.6 17,761 1

Nested Loop Left Join (cost=1.15..132,745.94 rows=1,307 width=252) (actual time=3.417..405.422 rows=17,761 loops=1)

2. 7.482 366.393 ↓ 13.6 17,761 1

Nested Loop Left Join (cost=0.87..132,327.07 rows=1,307 width=115) (actual time=3.411..366.393 rows=17,761 loops=1)

3. 5.561 252.345 ↓ 13.6 17,761 1

Nested Loop (cost=0.58..131,925.16 rows=1,307 width=79) (actual time=3.388..252.345 rows=17,761 loops=1)

4. 0.097 0.097 ↓ 1.2 119 1

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

5. 246.687 246.687 ↓ 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=79) (actual time=0.596..2.073 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
6. 106.566 106.566 ↑ 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.006..0.006 rows=1 loops=17,761)

  • Index Cond: ((cc.cmte_id)::text = (cmte_id)::text)
7. 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)