explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Klaa

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

Limit (cost=6.63..11.10 rows=1 width=88) (actual time=1,573.195..1,573.195 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.023 0.023 ↑ 1.0 1 1

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

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

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

  • Filter: ((tag)::text = 'cited'::text)
  • Rows Removed by Filter: 71
5. 348.120 1,573.195 ↑ 62,877,198,988.0 1 1

Nested Loop Left Join (cost=0.85..280,788,157,487.26 rows=62,877,198,988 width=88) (actual time=1,573.195..1,573.195 rows=1 loops=1)

  • Join Filter: (pt_co.casesoffensesid = pt_i.casesoffensesid)
  • Rows Removed by Join Filter: 1
6. 0.007 1,172.275 ↑ 62,877,198,988.0 1 1

Nested Loop Left Join (cost=0.43..233,585,912,180.01 rows=62,877,198,988 width=80) (actual time=1,172.275..1,172.275 rows=1 loops=1)

  • Join Filter: (pt_co.offensesid = v.z_z_offenses_offenses)
  • Rows Removed by Join Filter: 1
7. 0.359 687.862 ↑ 62,877,198,988.0 1 1

Nested Loop (cost=0.00..193,083,859,334.28 rows=62,877,198,988 width=72) (actual time=687.862..687.862 rows=1 loops=1)

  • Join Filter: (cv.violationid = v.id)
  • Rows Removed by Join Filter: 4696
8. 49.117 681.047 ↑ 490,940,453.0 1 1

Nested Loop (cost=0.00..4,452,261,849.88 rows=490,940,453 width=72) (actual time=681.047..681.047 rows=1 loops=1)

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

Nested Loop (cost=0.00..2,403,888,405.88 rows=248,070 width=60) (actual time=296.316..296.316 rows=1 loops=1)

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

Seq Scan on stg_combine_summons stg_cit (cost=0.00..53,935.20 rows=464,496 width=56) (actual time=0.005..0.005 rows=1 loops=1)

  • Filter: (wtrun = 1)
11. 53.040 273.585 ↓ 1.1 281,881 1

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

12. 220.545 220.545 ↓ 1.1 281,881 1

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

13. 113.541 335.614 ↓ 1.5 593,359 1

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

14. 222.073 222.073 ↓ 1.5 593,359 1

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

15. 0.578 6.456 ↑ 5.5 4,697 1

Materialize (cost=0.00..1,994.52 rows=25,615 width=8) (actual time=2.784..6.456 rows=4,697 loops=1)

16. 5.878 5.878 ↑ 5.5 4,697 1

Seq Scan on violation v (cost=0.00..1,866.44 rows=25,615 width=8) (actual time=2.781..5.878 rows=4,697 loops=1)

  • Filter: (z_z_offenses_offenses IS NOT NULL)
  • Rows Removed by Filter: 87
17. 484.406 484.406 ↑ 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=484.405..484.406 rows=1 loops=1)

  • Index Cond: (casesid = stg_cit.casesid)
18. 52.800 52.800 ↑ 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=52.799..52.800 rows=1 loops=1)

  • Index Cond: ((casesnamesid = stg_cit.casesnamesid) AND (involvementcodesid = $1))
Planning time : 1.035 ms
Execution time : 1,578.112 ms