explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MKS6

Settings
# exclusive inclusive rows x rows loops node
1. 38.346 791.170 ↓ 0.0 0 1

ModifyTable on public.namespace_statistics (cost=0.86..4,531.06 rows=77 width=32) (actual time=791.170..791.170 rows=0 loops=1)

  • Buffers: shared hit=3,730 read=418 dirtied=164
  • I/O Timings: read=745.748
2. 4.412 752.824 ↓ 1.3 98 1

Nested Loop (cost=0.86..4,531.06 rows=77 width=32) (actual time=3.642..752.824 rows=98 loops=1)

  • Buffers: shared hit=3,201 read=399 dirtied=92
  • I/O Timings: read=713.960
3. 733.148 733.148 ↑ 1.1 954 1

Index Scan using namespaces_pkey on public.namespaces (cost=0.43..1,472.29 rows=1,004 width=10) (actual time=3.579..733.148 rows=954 loops=1)

  • Index Cond: ((namespaces.id >= 1) AND (namespaces.id <= 1,000))
  • Buffers: shared hit=241 read=399 dirtied=4
  • I/O Timings: read=713.960
4. 15.264 15.264 ↓ 0.0 0 954

Index Scan using index_namespace_statistics_on_namespace_id on public.namespace_statistics (cost=0.42..3.05 rows=1 width=14) (actual time=0.016..0.016 rows=0 loops=954)

  • Index Cond: (namespace_statistics.namespace_id = namespaces.id)
  • Buffers: shared hit=2,960 dirtied=88