explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sojP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on item_descriptions (cost=30,903.65..213,178.15 rows=17 width=25) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* (cost=30,903.65..213,178.15 rows=17 width=25) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=30,903.65..213,177.93 rows=17 width=17) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=30,903.65..213,177.93 rows=17 width=17) (actual rows= loops=)

  • Hash Cond: ((names.cad_incidentsid = inc.cad_incidentsid) AND (names.namesid = inc.initial_reporter_namesid))
5. 0.000 0.000 ↓ 0.0

Seq Scan on cad_incidents_names names (cost=0.00..8,422.05 rows=284,705 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=25,352.06..25,352.06 rows=266,106 width=17) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

8.          

SubPlan (forHash Join)

9. 0.000 0.000 ↓ 0.0

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

  • Filter: ((cad_incidentsid = inc.cad_incidentsid) AND (namesid = inc.initial_reporter_namesid))