explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lX96

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 5,714.644 ↑ 65.0 1 1

HashAggregate (cost=195,997.79..195,998.44 rows=65 width=33) (actual time=5,714.643..5,714.644 rows=1 loops=1)

  • Group Key: o.id, o.name
2. 102.067 5,714.565 ↑ 207,840.0 17 1

Nested Loop (cost=1,335.77..178,331.39 rows=3,533,280 width=33) (actual time=585.483..5,714.565 rows=17 loops=1)

3. 42.835 92.893 ↑ 8.3 424,585 1

Nested Loop (cost=1,335.51..107,665.53 rows=3,533,280 width=8,471) (actual time=2.972..92.893 rows=424,585 loops=1)

4. 0.000 24.063 ↓ 3.3 8,665 1

Gather (cost=1,335.51..63,472.53 rows=2,598 width=8,439) (actual time=2.951..24.063 rows=8,665 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 7.664 124.781 ↓ 2.7 2,888 3 / 3

Hash Join (cost=335.51..62,212.73 rows=1,082 width=8,439) (actual time=2.601..124.781 rows=2,888 loops=3)

  • Hash Cond: (psmorg.psmorgid = o.id)
6. 115.017 115.017 ↑ 1.2 121,189 3 / 3

Parallel Seq Scan on psmgisareas psmorg (cost=0.00..59,964.86 rows=151,486 width=8,410) (actual time=0.120..115.017 rows=121,189 loops=3)

7. 0.025 2.100 ↑ 1.0 65 3 / 3

Hash (cost=334.70..334.70 rows=65 width=33) (actual time=2.100..2.100 rows=65 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
8. 2.075 2.075 ↑ 1.0 65 3 / 3

Seq Scan on organisation o (cost=0.00..334.70 rows=65 width=33) (actual time=0.163..2.075 rows=65 loops=3)

  • Filter: isprojectmodule
  • Rows Removed by Filter: 6,405
9. 25.978 25.995 ↑ 27.8 49 8,665

Materialize (cost=0.00..30.40 rows=1,360 width=32) (actual time=0.000..0.003 rows=49 loops=8,665)

10. 0.017 0.017 ↑ 27.8 49 1

Seq Scan on loggedinorgareatable (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.010..0.017 rows=49 loops=1)

11. 5,519.605 5,519.605 ↓ 0.0 0 424,585

Function Scan on x (cost=0.25..0.26 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=424,585)

  • Filter: x
  • Rows Removed by Filter: 1