explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T5mx

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

Finalize Aggregate (cost=44,366.720..44,366.730 rows=1 width=32) (actual time=417.474..417.475 rows=1 loops=1)

2. 6.834 417.495 ↓ 1.5 3 1

Gather (cost=44,366.490..44,366.700 rows=2 width=32) (actual time=415.763..417.495 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 9.998 410.661 ↑ 1.0 1 3

Partial Aggregate (cost=43,366.490..43,366.500 rows=1 width=32) (actual time=410.661..410.661 rows=1 loops=3)

4. 80.818 400.663 ↑ 1.1 9,482 3

Hash Join (cost=16.870..43,340.470 rows=10,410 width=5) (actual time=51.599..400.663 rows=9,482 loops=3)

  • Hash Cond: (foxtrot.charlie = sierra.quebec)
5. 319.737 319.737 ↑ 1.2 103,823 3

Parallel Seq Scan on foxtrot (cost=0.000..42,985.340 rows=127,598 width=13) (actual time=35.639..319.737 rows=103,823 loops=3)

  • Filter: ((hotel)::text <> 'papa'::text)
  • Rows Removed by Filter: 511153
6. 0.016 0.108 ↑ 2.2 16 3

Hash (cost=16.430..16.430 rows=35 width=8) (actual time=0.107..0.108 rows=16 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.092 0.092 ↑ 2.2 16 3

Seq Scan on sierra (cost=0.000..16.430 rows=35 width=8) (actual time=0.025..0.092 rows=16 loops=3)

  • Filter: ((four = 5) AND (kilo = 155))
  • Rows Removed by Filter: 413