explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3LDx : Optimization for: plan #UUXw

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.059 5.818 ↑ 16.7 6 1

Nested Loop Left Join (cost=0.70..871.78 rows=100 width=36) (actual time=0.894..5.818 rows=6 loops=1)

2. 0.008 5.705 ↑ 16.7 6 1

Nested Loop (cost=0.43..842.02 rows=100 width=8) (actual time=0.844..5.705 rows=6 loops=1)

3. 0.008 0.009 ↑ 16.7 6 1

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

4. 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)

5. 5.688 5.688 ↑ 1.0 1 6

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

  • Index Cond: (id = (unnest('{20066,21700,20753,21539,21600,21549}'::integer[])))
6. 0.054 0.054 ↑ 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.009..0.009 rows=1 loops=6)

  • Index Cond: (id = po.po_type_id)
Planning time : 1.460 ms
Execution time : 5.871 ms