explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lJLv

Settings
# exclusive inclusive rows x rows loops node
1. 1,751.804 4,537.340 ↑ 2,579.8 650 1

Hash Join (cost=246,056.24..374,549.20 rows=1,676,878 width=4) (actual time=3,172.283..4,537.340 rows=650 loops=1)

  • Hash Cond: (deal_state.last_status_id = last_status.id)
2. 784.676 784.676 ↑ 1.0 3,896,326 1

Seq Scan on deal_state (cost=0.00..72,992.93 rows=3,896,393 width=8) (actual time=0.024..784.676 rows=3,896,326 loops=1)

3. 726.144 2,000.860 ↓ 1.0 3,846,796 1

Hash (cost=183,772.50..183,772.50 rows=3,796,299 width=4) (actual time=2,000.860..2,000.860 rows=3,846,796 loops=1)

  • Buckets: 131,072 Batches: 64 Memory Usage: 3,133kB
4. 1,274.716 1,274.716 ↓ 1.0 3,846,796 1

Seq Scan on deal_status last_status (cost=0.00..183,772.50 rows=3,796,299 width=4) (actual time=1.868..1,274.716 rows=3,846,796 loops=1)

  • Filter: (state = 'REVIEW'::text)
  • Rows Removed by Filter: 4,974,271
Planning time : 0.342 ms
Execution time : 4,537.827 ms