explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8n7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 292.515 ↑ 1.0 1 1

Aggregate (cost=45,517.44..45,517.45 rows=1 width=8) (actual time=292.514..292.515 rows=1 loops=1)

  • Buffers: shared hit=672 read=22000
2. 10.723 294.143 ↑ 1.0 1 1

Gather (cost=1,000.00..45,517.44 rows=1 width=0) (actual time=3.891..294.143 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=672 read=22000
3. 283.420 283.420 ↓ 0.0 0 3

Parallel Seq Scan on test (cost=0.00..44,517.34 rows=1 width=0) (actual time=187.318..283.420 rows=0 loops=3)

  • Filter: (id = 4128)
  • Rows Removed by Filter: 1398101
  • Buffers: shared hit=672 read=22000