explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HW85

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 1,923.120 ↑ 1.0 100 1

Limit (cost=659,865.78..659,867.58 rows=100 width=8) (actual time=1,923.069..1,923.120 rows=100 loops=1)

  • Buffers: shared hit=343,540 read=59,320, temp read=1,029 written=4,585
  • I/O Timings: read=185.321
2. 0.020 1,923.110 ↑ 12,047.3 100 1

Unique (cost=659,865.78..669,573.92 rows=1,204,730 width=8) (actual time=1,923.068..1,923.110 rows=100 loops=1)

  • Buffers: shared hit=343,540 read=59,320, temp read=1,029 written=4,585
  • I/O Timings: read=185.321
3. 808.601 1,923.090 ↑ 13,483.5 144 1

Sort (cost=659,865.78..664,719.85 rows=1,941,629 width=8) (actual time=1,923.067..1,923.090 rows=144 loops=1)

  • Sort Key: ebox_message.id
  • Sort Method: external merge Disk: 36,632kB
  • Buffers: shared hit=343,540 read=59,320, temp read=1,029 written=4,585
  • I/O Timings: read=185.321
4. 1,114.489 1,114.489 ↓ 1.1 2,085,280 1

Seq Scan on ebox_message (cost=0.00..432,422.67 rows=1,941,629 width=8) (actual time=0.010..1,114.489 rows=2,085,280 loops=1)

  • Filter: ((id > '3000000121896'::bigint) AND (id > '3000000121896'::bigint))
  • Rows Removed by Filter: 31,156
  • Buffers: shared hit=343,537 read=59,320
  • I/O Timings: read=185.321
Planning time : 3.213 ms
Execution time : 1,933.105 ms