explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2m2f

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.027 ↑ 1.0 1 1

Nested Loop (cost=1.29..25.37 rows=1 width=1) (actual time=0.026..0.027 rows=1 loops=1)

2. 0.001 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.86..16.90 rows=1 width=4) (actual time=0.020..0.021 rows=1 loops=1)

3. 0.010 0.010 ↑ 1.0 1 1

Index Scan using i_storeplaceitems_containerwithamount on storeplaceitems spi (cost=0.43..8.45 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((containerid)::integer = 11228030)
4. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using containers_pkey on containers c (cost=0.43..8.45 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (containerid = 11228030)
  • Heap Fetches: 1
5. 0.005 0.005 ↑ 1.0 1 1

Index Scan using storeplaces_pkey on storeplaces sp (cost=0.43..8.45 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ((storeplaceid)::integer = (spi.storeplaceid)::integer)
Planning time : 0.414 ms
Execution time : 0.059 ms