explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OG9a

Settings
# exclusive inclusive rows x rows loops node
1. 124.679 297.390 ↓ 0.0 0 1

ModifyTable on public.namespace_statistics (cost=0.42..106.16 rows=74 width=26) (actual time=297.390..297.390 rows=0 loops=1)

  • Buffers: shared hit=540 read=168 dirtied=148
  • I/O Timings: read=264.378
2. 172.711 172.711 ↓ 1.3 98 1

Index Scan using index_namespace_statistics_on_namespace_id on public.namespace_statistics (cost=0.42..106.16 rows=74 width=26) (actual time=0.019..172.711 rows=98 loops=1)

  • Index Cond: ((namespace_statistics.namespace_id >= 1) AND (namespace_statistics.namespace_id <= 1,000))
  • Buffers: shared hit=4 read=97 dirtied=9
  • I/O Timings: read=149.715