explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SjgX

Settings
# exclusive inclusive rows x rows loops node
1. 5.261 77.126 ↓ 1.6 2,121 1

Sort (cost=132,228.82..132,232.09 rows=1,307 width=616) (actual time=76.361..77.126 rows=2,121 loops=1)

  • Sort Key: cc.created_dt
  • Sort Method: quicksort Memory: 1369kB
2. 5.326 71.865 ↓ 1.6 2,121 1

Nested Loop Left Join (cost=1.15..132,161.17 rows=1,307 width=616) (actual time=3.284..71.865 rows=2,121 loops=1)

3. 4.049 62.297 ↓ 1.6 2,121 1

Nested Loop Left Join (cost=0.87..131,745.57 rows=1,307 width=494) (actual time=3.278..62.297 rows=2,121 loops=1)

4. 2.726 41.280 ↓ 1.6 2,121 1

Nested Loop (cost=0.58..131,343.66 rows=1,307 width=349) (actual time=3.253..41.280 rows=2,121 loops=1)

5. 0.019 0.019 ↑ 20.0 5 1

Function Scan on json_array_elements v1 (cost=0.00..1.00 rows=100 width=32) (actual time=0.013..0.019 rows=5 loops=1)

6. 38.535 38.535 ↓ 24.9 424 5

Index Scan using ix_contributions_fec_contributions_name_state_lw on contributions_fec_contributions cc (cost=0.57..1,313.26 rows=17 width=349) (actual time=1.918..7.707 rows=424 loops=5)

  • 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: 1461
7. 16.968 16.968 ↑ 1.0 1 2,121

Index Scan using contributions_fec_committees_pkey on contributions_fec_committees cfm (cost=0.29..0.31 rows=1 width=145) (actual time=0.008..0.008 rows=1 loops=2,121)

  • Index Cond: ((cc.cmte_id)::text = (cmte_id)::text)
8. 4.242 4.242 ↓ 0.0 0 2,121

Index Scan using contributions_fec_candidates_pkey on contributions_fec_candidates cfc (cost=0.29..0.32 rows=1 width=122) (actual time=0.002..0.002 rows=0 loops=2,121)

  • Index Cond: ((cfm.cand_id)::text = (cand_id)::text)
Planning time : 1.854 ms
Execution time : 77.662 ms