explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ABi

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.054 ↑ 34.0 1 1

HashAggregate (cost=28.25..28.59 rows=34 width=5) (actual time=0.054..0.054 rows=1 loops=1)

  • Group Key: ri.requestid
2. 0.004 0.045 ↓ 1.1 37 1

Nested Loop (cost=0.86..27.99 rows=34 width=12) (actual time=0.021..0.045 rows=37 loops=1)

3. 0.010 0.010 ↑ 1.0 1 1

Index Scan using i_requestcontainers_containerid on requestcontainers rc (cost=0.43..8.45 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ((containerid)::integer = 11228030)
4. 0.031 0.031 ↑ 1.6 37 1

Index Scan using i_requestitems_request on requestitems ri (cost=0.43..18.97 rows=58 width=12) (actual time=0.011..0.031 rows=37 loops=1)

  • Index Cond: ((requestid)::integer = (rc.requestid)::integer)
  • Filter: (objectstatusid = 1)
  • Rows Removed by Filter: 1
Planning time : 0.334 ms
Execution time : 0.098 ms