explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OHKK

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2,077.728 ↑ 1.0 1 1

Limit (cost=0.44..312,573.85 rows=1 width=435) (actual time=2,077.725..2,077.728 rows=1 loops=1)

  • Buffers: shared hit=1373 read=88813
2. 2,077.723 2,077.723 ↑ 1.0 1 1

Index Scan using pk_ar_transactions on ar_transactions ar_transactions (cost=0.44..312,573.85 rows=1 width=435) (actual time=2,077.722..2,077.723 rows=1 loops=1)

  • Index Cond: (ar_transactions.id = 385517594)
  • Buffers: shared hit=1373 read=88813