explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aCep

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 17,276.075 ↑ 1.0 1 1

Aggregate (cost=2.63..2.64 rows=1 width=32) (actual time=17,276.074..17,276.075 rows=1 loops=1)

  • Buffers: shared hit=1,636,612
2. 0.009 0.009 ↑ 1.0 1 1

Index Scan using instance_pkey on instance (cost=0.14..2.36 rows=1 width=642) (actual time=0.007..0.009 rows=1 loops=1)

  • Index Cond: (id = 79)
  • Buffers: shared hit=2
3.          

SubPlan (for Aggregate)

4. 17,276.037 17,276.037 ↑ 1.0 1 1

Result (cost=0.00..0.26 rows=1 width=32) (actual time=17,276.037..17,276.037 rows=1 loops=1)

  • Buffers: shared hit=1,636,610
Planning time : 0.212 ms
Execution time : 17,276.109 ms