explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TGG

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.006 ↓ 0.0 0 1

Hash Join (cost=23.60..57.18 rows=30 width=107) (actual time=0.006..0.006 rows=0 loops=1)

  • Hash Cond: (("PC0".pyemailaddress)::text = (subscription.emailid)::text)
  • Join Filter: (((events.lasteventtime > subscription.lasteventprocessedtime) AND (subscription.lasteventprocessedtime IS NOT NULL)) OR ((events.lasteventtime IS NOT NULL) AND (subscription.lasteventprocessedtime IS NULL)))
2. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.80..44.79 rows=89 width=525) (never executed)

  • Hash Cond: (("PC0".pyemailaddress)::text = (events.emailid)::text)
3. 0.000 0.000 ↓ 0.0 0

Seq Scan on pr_operators "PC0" (cost=0.00..30.67 rows=381 width=99) (never executed)

  • Filter: (((pxobjclass)::text = ANY ('{Data-Admin-Operator-ID,Data-Admin-Operator-ID-SMDAppReport,Data-Admin-Operator-ID-SMDApps}'::text[])) AND ((pxobjclass)::text = ANY ('{Data-Admin-Operator-ID,Data-Admin-Operator-ID-SMDAppReport,Data-Admin (...)
4. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.80..10.80 rows=80 width=426) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on crm_push_events_data events (cost=0.00..10.80 rows=80 width=426) (never executed)

6. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=426) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
7. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on crm_push_subscription_data subscription (cost=0.00..10.80 rows=80 width=426) (actual time=0.001..0.001 rows=0 loops=1)