explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v4vj

Settings
# exclusive inclusive rows x rows loops node
1. 2.436 15,337.809 ↓ 0.0 0 1

Insert on item_descriptions (cost=30,903.65..213,178.15 rows=17 width=25) (actual time=15,337.809..15,337.809 rows=0 loops=1)

2. 1.110 15,335.373 ↓ 5.9 100 1

Subquery Scan on *SELECT* (cost=30,903.65..213,178.15 rows=17 width=25) (actual time=914.677..15,335.373 rows=100 loops=1)

3. 0.094 15,334.263 ↓ 5.9 100 1

Limit (cost=30,903.65..213,177.93 rows=17 width=17) (actual time=914.660..15,334.263 rows=100 loops=1)

4. 88.340 15,334.169 ↓ 5.9 100 1

Hash Join (cost=30,903.65..213,177.93 rows=17 width=17) (actual time=914.659..15,334.169 rows=100 loops=1)

  • Hash Cond: ((names.cad_incidentsid = inc.cad_incidentsid) AND (names.namesid = inc.initial_reporter_namesid))
5. 60.962 60.962 ↑ 2.6 107,486 1

Seq Scan on cad_incidents_names names (cost=0.00..8,422.05 rows=284,705 width=16) (actual time=0.009..60.962 rows=107,486 loops=1)

6. 204.326 626.067 ↑ 1.5 178,667 1

Hash (cost=25,352.06..25,352.06 rows=266,106 width=17) (actual time=626.067..626.067 rows=178,667 loops=1)

  • Buckets: 32768 Batches: 16 Memory Usage: 797kB
7. 421.741 421.741 ↑ 1.0 266,106 1

Seq Scan on stg_combined_incidents inc (cost=0.00..25,352.06 rows=266,106 width=17) (actual time=0.006..421.741 rows=266,106 loops=1)

8.          

SubPlan (forHash Join)

9. 14,558.800 14,558.800 ↑ 1.0 1 100

Seq Scan on cad_incidents_names names_1 (cost=0.00..9,845.58 rows=1 width=8) (actual time=54.375..145.588 rows=1 loops=100)

  • Filter: ((cad_incidentsid = inc.cad_incidentsid) AND (namesid = inc.initial_reporter_namesid))
  • Rows Removed by Filter: 284704