explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lQFW

Settings
# exclusive inclusive rows x rows loops node
1. 6.272 487.082 ↓ 197.6 4,149 1

Sort (cost=23,740.28..23,740.34 rows=21 width=28) (actual time=484.635..487.082 rows=4,149 loops=1)

  • Output: tid, creation_ts
  • Sort Key: history.creation_ts
  • Sort Method: quicksort Memory: 517kB
  • Buffers: shared hit=3500 read=5024 dirtied=5
2. 480.810 480.810 ↓ 197.6 4,149 1

Index Scan using history_un on public.history (cost=0.43..23,739.82 rows=21 width=28) (actual time=310.068..480.810 rows=4,149 loops=1)

  • Output: tid, creation_ts
  • Index Cond: (history.contractor = 'CO_PAYMASTER'::_contractors)
  • Filter: ((history.tstatus <> ALL ('{SUCCESS,FAILURE}'::statuses[])) AND (history.creation_ts > '1453388028767619'::bigint))
  • Rows Removed by Filter: 11244
  • Buffers: shared hit=3500 read=5024 dirtied=5
Planning time : 1.123 ms
Execution time : 487.395 ms