explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gYrZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 29.384 ↑ 1.0 1 1

Aggregate (cost=27,464.45..27,464.46 rows=1 width=8) (actual time=29.384..29.384 rows=1 loops=1)

2. 1.148 29.318 ↑ 1.8 480 1

Hash Join (cost=326.96..27,462.32 rows=850 width=4) (actual time=2.276..29.318 rows=480 loops=1)

  • Hash Cond: (sd.cid = c.id)
3. 26.450 27.146 ↓ 1.0 7,455 1

Bitmap Heap Scan on settlement_distributions sd (cost=136.44..27,252.81 rows=7,226 width=8) (actual time=1.113..27.146 rows=7,455 loops=1)

  • Recheck Cond: (emailed_on IS NULL)
  • Heap Blocks: exact=3,015
4. 0.696 0.696 ↓ 1.0 7,455 1

Bitmap Index Scan on idx_emailed_on (cost=0.00..134.63 rows=7,226 width=0) (actual time=0.696..0.696 rows=7,455 loops=1)

  • Index Cond: (emailed_on IS NULL)
5. 0.065 1.024 ↓ 1.0 492 1

Hash (cost=184.46..184.46 rows=485 width=4) (actual time=1.024..1.024 rows=492 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 26kB
6. 0.959 0.959 ↓ 1.0 492 1

Seq Scan on clients c (cost=0.00..184.46 rows=485 width=4) (actual time=0.015..0.959 rows=492 loops=1)

  • Filter: (database_id = ANY ('{516,411,480,535,742,789,1086,887}'::integer[]))
  • Rows Removed by Filter: 3,640
Planning time : 1.646 ms
Execution time : 29.472 ms