explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qyeu

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

Finalize Aggregate (cost=37,923.13..37,923.14 rows=1 width=32) (actual time=551.419..551.419 rows=1 loops=1)

2. 27.200 552.420 ↓ 1.5 3 1

Gather (cost=37,922.92..37,923.13 rows=2 width=32) (actual time=551.403..552.420 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.032 525.220 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=36,922.92..36,922.93 rows=1 width=32) (actual time=525.220..525.220 rows=1 loops=3)

4. 112.638 525.188 ↑ 1.2 33 3 / 3

Hash Join (cost=21,847.24..36,922.82 rows=41 width=33) (actual time=443.664..525.188 rows=33 loops=3)

  • Hash Cond: (t2.id = t1.id)
5. 122.212 122.212 ↑ 1.3 333,333 3 / 3

Parallel Seq Scan on t2 (cost=0.00..13,512.67 rows=416,667 width=4) (actual time=0.008..122.212 rows=333,333 loops=3)

6. 0.032 290.338 ↓ 1.0 100 3 / 3

Hash (cost=21,846.00..21,846.00 rows=99 width=37) (actual time=290.338..290.338 rows=100 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
7. 290.306 290.306 ↓ 1.0 100 3 / 3

Seq Scan on t1 (cost=0.00..21,846.00 rows=99 width=37) (actual time=0.024..290.306 rows=100 loops=3)

  • Filter: (clus = 1)
  • Rows Removed by Filter: 999900
Planning time : 0.717 ms
Execution time : 558.347 ms