explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0gSj

Settings
# exclusive inclusive rows x rows loops node
1. 229.740 3,366.991 ↑ 1.0 1 1

Aggregate (cost=49,705.68..49,705.69 rows=1 width=8) (actual time=3,366.991..3,366.991 rows=1 loops=1)

  • Buffers: shared hit=136,576 read=7,986 dirtied=1,496
  • I/O Timings: read=2,410.188
2. 3,137.251 3,137.251 ↓ 1.0 2,329,375 1

Index Only Scan using security_scans_pkey on public.security_scans (cost=0.43..43,993.93 rows=2,284,700 width=0) (actual time=4.125..3,137.251 rows=2,329,375 loops=1)

  • Heap Fetches: 153,250
  • Buffers: shared hit=136,576 read=7,986 dirtied=1,496
  • I/O Timings: read=2,410.188