explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WqM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,180.272 ↑ 1.0 1 1

Limit (cost=6.63..11.08 rows=1 width=88) (actual time=2,180.272..2,180.272 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on involvementcodes (cost=0.00..2.89 rows=1 width=8) (actual time=0.012..0.015 rows=1 loops=1)

  • Filter: ((code)::text = 'Cite'::text)
  • Rows Removed by Filter: 71
4. 0.706 0.706 ↑ 1.0 1 1

Seq Scan on involvementcodes involvementcodes_1 (cost=0.00..2.89 rows=1 width=8) (actual time=0.694..0.706 rows=1 loops=1)

  • Filter: ((tag)::text = 'cited'::text)
  • Rows Removed by Filter: 71
5. 32.982 2,180.271 ↑ 80,580,511,121.0 1 1

Nested Loop Left Join (cost=0.85..358,612,519,353.45 rows=80,580,511,121 width=88) (actual time=2,180.271..2,180.271 rows=1 loops=1)

  • Join Filter: (pt_co.casesoffensesid = pt_i.casesoffensesid)
  • Rows Removed by Join Filter: 1
6. 0.009 2,120.124 ↑ 80,580,511,121.0 1 1

Nested Loop Left Join (cost=0.43..298,106,951,777.40 rows=80,580,511,121 width=80) (actual time=2,120.124..2,120.124 rows=1 loops=1)

  • Join Filter: (pt_co.offensesid = v.z_z_offenses_offenses)
  • Rows Removed by Join Filter: 1
7. 0.758 2,105.627 ↑ 80,580,511,121.0 1 1

Nested Loop (cost=0.00..246,192,354,240.89 rows=80,580,511,121 width=72) (actual time=2,105.627..2,105.627 rows=1 loops=1)

  • Join Filter: (cv.violationid = v.id)
  • Rows Removed by Join Filter: 4743
8. 57.534 1,896.559 ↑ 490,940,453.0 1 1

Nested Loop (cost=0.00..4,450,818,007.44 rows=490,940,453 width=72) (actual time=1,896.559..1,896.559 rows=1 loops=1)

  • Join Filter: (c.id = cv.citationid)
  • Rows Removed by Join Filter: 593358
9. 22.466 488.106 ↑ 248,070.0 1 1

Nested Loop (cost=0.00..2,402,444,563.44 rows=248,070 width=60) (actual time=488.106..488.106 rows=1 loops=1)

  • Join Filter: (c.citation_zid = stg_cit.convertedid)
  • Rows Removed by Join Filter: 281880
10. 0.010 0.010 ↑ 464,217.0 1 1

Seq Scan on stg_combine_summons stg_cit (cost=0.00..53,931.71 rows=464,217 width=56) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (wtrun = 1)
11. 52.771 465.630 ↓ 1.1 281,881 1

Materialize (cost=0.00..46,520.05 rows=248,070 width=20) (actual time=2.844..465.630 rows=281,881 loops=1)

12. 412.859 412.859 ↓ 1.1 281,881 1

Seq Scan on citation c (cost=0.00..43,825.70 rows=248,070 width=20) (actual time=2.840..412.859 rows=281,881 loops=1)

13. 132.526 1,350.919 ↓ 1.5 593,359 1

Materialize (cost=0.00..32,995.12 rows=395,808 width=20) (actual time=10.938..1,350.919 rows=593,359 loops=1)

14. 1,218.393 1,218.393 ↓ 1.5 593,359 1

Seq Scan on citationviolation cv (cost=0.00..28,696.08 rows=395,808 width=20) (actual time=10.933..1,218.393 rows=593,359 loops=1)

15. 1.213 208.310 ↑ 6.9 4,744 1

Materialize (cost=0.00..2,556.06 rows=32,827 width=8) (actual time=164.055..208.310 rows=4,744 loops=1)

16. 207.097 207.097 ↑ 6.9 4,744 1

Seq Scan on violation v (cost=0.00..2,391.92 rows=32,827 width=8) (actual time=164.050..207.097 rows=4,744 loops=1)

  • Filter: (z_z_offenses_offenses IS NOT NULL)
  • Rows Removed by Filter: 87
17. 14.488 14.488 ↑ 1.0 1 1

Index Scan using pt_casesoffenses_casesid_idx on pt_casesoffenses pt_co (cost=0.43..0.63 rows=1 width=24) (actual time=14.487..14.488 rows=1 loops=1)

  • Index Cond: (casesid = stg_cit.casesid)
18. 27.165 27.165 ↑ 1.0 1 1

Index Scan using pt_involvements_casesnamesid_casesoffensesid_involvementcodesid on pt_involvements pt_i (cost=0.43..0.72 rows=1 width=24) (actual time=27.163..27.165 rows=1 loops=1)

  • Index Cond: ((casesnamesid = stg_cit.casesnamesid) AND (involvementcodesid = $1))
Planning time : 58.827 ms
Execution time : 2,189.656 ms