explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gu0h : Optimization for: test; plan #rBmR

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.142 1,830.541 ↓ 0.0 0 1

Update on profile_tbl cp (cost=66,444.43..137,145.60 rows=36,432 width=674) (actual time=1,830.541..1,830.541 rows=0 loops=1)

2. 648.111 1,830.399 ↑ 36,432.0 1 1

Hash Join (cost=66,444.43..137,145.60 rows=36,432 width=674) (actual time=1,827.524..1,830.399 rows=1 loops=1)

  • Hash Cond: (cc.customerid = cp.id)
3. 702.566 702.566 ↓ 1.2 1,489,737 1

Seq Scan on contact_tbl cc (cost=0.00..48,473.93 rows=1,241,313 width=10) (actual time=0.005..702.566 rows=1,489,737 loops=1)

  • Filter: ((NOT mobile_verified) AND (NOT email_verified) AND (contacttypeid = 1))
  • Rows Removed by Filter: 245663
4. 84.974 479.722 ↓ 2.0 123,536 1

Hash (cost=60,585.85..60,585.85 rows=61,967 width=647) (actual time=479.722..479.722 rows=123,536 loops=1)

  • Buckets: 32768 Batches: 4 Memory Usage: 5531kB
5. 394.748 394.748 ↓ 2.0 123,536 1

Seq Scan on profile_tbl cp (cost=0.00..60,585.85 rows=61,967 width=647) (actual time=0.099..394.748 rows=123,536 loops=1)

  • Filter: ((NOT guest) AND enabled AND (profileid IS NULL) AND (created < now()))
  • Rows Removed by Filter: 1947390