explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3hWV

Settings
# exclusive inclusive rows x rows loops node
1. 519.881 2,128.827 ↓ 0.0 0 1

Hash Join (cost=11.29..51,976.54 rows=28,532 width=8) (actual time=2,128.826..2,128.827 rows=0 loops=1)

  • Hash Cond: (o.member_id = m.id)
  • Join Filter: (o.confirmed_at < timezone((m.operational_time_zone)::text, date_trunc('day'::text, timezone((m.operational_time_zone)::text, now()))))
  • Rows Removed by Join Filter: 405867
2. 1,608.924 1,608.924 ↓ 1.6 405,867 1

Index Scan using operations_status_index on operations o (cost=0.56..51,224.36 rows=256,785 width=16) (actual time=0.068..1,608.924 rows=405,867 loops=1)

  • Index Cond: ((status)::text = 'confirmed'::text)
  • Filter: ((receiver_type)::text = 'legal'::text)
  • Rows Removed by Filter: 323392
3. 0.006 0.022 ↑ 10.0 1 1

Hash (cost=10.60..10.60 rows=10 width=520) (actual time=0.022..0.022 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.016 0.016 ↑ 10.0 1 1

Seq Scan on members m (cost=0.00..10.60 rows=10 width=520) (actual time=0.015..0.016 rows=1 loops=1)

  • Filter: ((timezone((operational_time_zone)::text, now()))::time without time zone >= operational_date_end)