explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9bmb : EXPLAIN ANALYZE SELECT COUNT(*) FROM parsed_sight_21.booking

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

Finalize Aggregate (cost=13,498.93..13,498.94 rows=1 width=8) (actual time=153.624..153.625 rows=1 loops=1)

2. 4.770 155.278 ↓ 1.5 3 1

Gather (cost=13,498.72..13,498.93 rows=2 width=8) (actual time=153.614..155.278 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 7.752 150.508 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=12,498.72..12,498.73 rows=1 width=8) (actual time=150.508..150.508 rows=1 loops=3)

4. 142.756 142.756 ↑ 1.2 98,865 3 / 3

Parallel Index Only Scan using booking_pkey on booking (cost=0.42..12,189.82 rows=123,558 width=0) (actual time=0.715..142.756 rows=98,865 loops=3)

  • Heap Fetches: 483
Planning time : 1.361 ms
Execution time : 155.332 ms