explain.depesz.com

PostgreSQL's explain analyze made readable

Result: otCB

Settings
# exclusive inclusive rows x rows loops node
1. 583.160 1,555.824 ↓ 1.2 20,484 1

HashAggregate (cost=28,638.49..28,689.48 rows=16,998 width=23) (actual time=1,547.975..1,555.824 rows=20,484 loops=1)

  • Group Key: contact_id
2. 972.664 972.664 ↓ 1.0 469,655 1

Seq Scan on users_audit ua (cost=0.00..28,169.45 rows=469,036 width=23) (actual time=0.010..972.664 rows=469,655 loops=1)

  • Filter: ((updated_at < '2020-03-17 06:00:00+00'::timestamp with time zone) AND (total_login_successes > 0))
  • Rows Removed by Filter: 184942
Planning time : 0.247 ms
Execution time : 1,557.357 ms