explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ydgp

Settings
# exclusive inclusive rows x rows loops node
1. 128.725 589.701 ↑ 5.5 251,673 1

Hash Join (cost=23.18..665,379.97 rows=1,391,048 width=48) (actual time=0.048..589.701 rows=251,673 loops=1)

  • Hash Cond: ((unnest("Communication".teams)) = t.id)
2. 240.228 460.949 ↑ 138.2 251,673 1

ProjectSet (cost=0.00..224,372.84 rows=34,776,200 width=32) (actual time=0.014..460.949 rows=251,673 loops=1)

3. 220.721 220.721 ↑ 1.0 347,762 1

Seq Scan on "Communication" (cost=0.00..47,883.62 rows=347,762 width=46) (actual time=0.010..220.721 rows=347,762 loops=1)

4. 0.007 0.027 ↑ 1.0 8 1

Hash (cost=23.08..23.08 rows=8 width=32) (actual time=0.027..0.027 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.020 0.020 ↑ 1.0 8 1

Seq Scan on "Teams" t (cost=0.00..23.08 rows=8 width=32) (actual time=0.002..0.020 rows=8 loops=1)