explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8WiQ

Settings
# exclusive inclusive rows x rows loops node
1. 46,442.118 177,179.624 ↓ 13.6 4,095,657 1

HashAggregate (cost=8,179,043.15..8,182,059.54 rows=301,639 width=8) (actual time=173,541.630..177,179.624 rows=4,095,657 loops=1)

2. 130,737.506 130,737.506 ↑ 2.6 41,087,183 1

Seq Scan on action_states (cost=0.00..7,648,077.60 rows=106,193,110 width=8) (actual time=0.036..130,737.506 rows=41,087,183 loops=1)

  • Filter: (((state)::text <> 'unpaid'::text) AND ((state)::text <> 'machinel_fetched'::text) AND ((state)::text <> 'acc_merged'::text) AND ((state)::text <> 'graylist_reason'::text) AND ((state)::text <> 'trafi_fetched'::text) AND ((state)::text <> 'pending_polepos'::text) AND ((state)::text <> 'reg'::text) AND ((state)::text <> 'pending_bump'::text) AND ((state)::text <> 'graylist'::text))
  • Rows Removed by Filter: 23,091,018
Total runtime : 179,113.364 ms