explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UUXw

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.787 9.608 ↑ 16.7 6 1

Nested Loop Left Join (cost=2.47..873.03 rows=100 width=36) (actual time=3.517..9.608 rows=6 loops=1)

2. 0.016 8.755 ↑ 16.7 6 1

Nested Loop (cost=2.20..843.27 rows=100 width=8) (actual time=2.755..8.755 rows=6 loops=1)

3. 0.010 0.015 ↑ 16.7 6 1

HashAggregate (cost=1.77..2.77 rows=100 width=4) (actual time=0.009..0.015 rows=6 loops=1)

  • Group Key: unnest('{20066,21700,20753,21539,21600,21549}'::integer[])
4. 0.004 0.005 ↑ 16.7 6 1

ProjectSet (cost=0.00..0.52 rows=100 width=4) (actual time=0.003..0.005 rows=6 loops=1)

5. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

6. 8.724 8.724 ↑ 1.0 1 6

Index Scan using po_pkey on po (cost=0.43..8.40 rows=1 width=8) (actual time=1.454..1.454 rows=1 loops=6)

  • Index Cond: (id = (unnest('{20066,21700,20753,21539,21600,21549}'::integer[])))
7. 0.066 0.066 ↑ 1.0 1 6

Index Scan using inspections_purchaseordertype_pkey on inspections_purchaseordertype pot (cost=0.28..0.29 rows=1 width=11) (actual time=0.011..0.011 rows=1 loops=6)

  • Index Cond: (id = po.po_type_id)
Planning time : 2.062 ms
Execution time : 9.996 ms