explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F2Sz

Settings
# exclusive inclusive rows x rows loops node
1. 219,573.228 225,462.640 ↑ 1.0 758,117,088 1

Hash Join (cost=442,921.22..9,072,226.71 rows=758,442,658 width=26) (actual time=5,983.791..225,462.640 rows=758,117,088 loops=1)

  • Hash Cond: ((am.demo_block)::text = ld.demo_block)
2. 0.730 0.730 ↑ 1.0 2,544 1

Seq Scan on audience_map am (cost=0.00..54.44 rows=2,544 width=29) (actual time=0.018..0.730 rows=2,544 loops=1)

3. 3,111.972 5,888.682 ↓ 1.0 8,940,060 1

Hash (cost=261,325.54..261,325.54 rows=8,940,054 width=35) (actual time=5,888.682..5,888.682 rows=8,940,060 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 512 (originally 256) Memory Usage: 39288kB
4. 2,776.710 2,776.710 ↓ 1.0 8,940,060 1

Seq Scan on live_delivery ld (cost=0.00..261,325.54 rows=8,940,054 width=35) (actual time=0.016..2,776.710 rows=8,940,060 loops=1)