explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FnKY : live_delivery222

Settings
# exclusive inclusive rows x rows loops node
1. 0.136 3,000.305 ↑ 75.7 292 1

Append (cost=0.00..762,426.70 rows=22,112 width=1,177) (actual time=1,838.170..3,000.305 rows=292 loops=1)

  • Buffers: shared hit=118 read=701499 written=12
2. 30.710 30.710 ↓ 0.0 0 1

Seq Scan on delivery (cost=0.00..7,932.03 rows=1,464 width=80) (actual time=30.710..30.710 rows=0 loops=1)

  • Filter: ((endtime)::integer = ANY ('{1555142641}'::integer[]))
  • Rows Removed by Filter: 23096
  • Buffers: shared read=3905 written=5
3. 644.935 644.935 ↓ 0.0 0 1

Seq Scan on delivery_1554930000 (cost=0.00..168,977.67 rows=4,629 width=1,253) (actual time=644.935..644.935 rows=0 loops=1)

  • Filter: ((endtime)::integer = ANY ('{1555142641}'::integer[]))
  • Rows Removed by Filter: 926252
  • Buffers: shared read=156248 written=7
4. 685.084 685.084 ↓ 0.0 0 1

Seq Scan on delivery_1555016400 (cost=0.00..169,169.47 rows=4,638 width=1,253) (actual time=685.084..685.084 rows=0 loops=1)

  • Filter: ((endtime)::integer = ANY ('{1555142641}'::integer[]))
  • Rows Removed by Filter: 926610
  • Buffers: shared read=156415
5. 626.362 626.362 ↑ 14.2 292 1

Seq Scan on delivery_1555102800 (cost=0.00..151,842.75 rows=4,157 width=1,253) (actual time=477.432..626.362 rows=292 loops=1)

  • Filter: ((endtime)::integer = ANY ('{1555142641}'::integer[]))
  • Rows Removed by Filter: 831145
  • Buffers: shared read=140410
6. 551.596 551.596 ↓ 0.0 0 1

Seq Scan on delivery_1555189200 (cost=0.00..147,079.82 rows=4,017 width=1,258) (actual time=551.596..551.596 rows=0 loops=1)

  • Filter: ((endtime)::integer = ANY ('{1555142641}'::integer[]))
  • Rows Removed by Filter: 803676
  • Buffers: shared read=136034
7. 461.482 461.482 ↓ 0.0 0 1

Seq Scan on delivery_1555275600 (cost=0.00..117,424.96 rows=3,207 width=1,258) (actual time=461.482..461.482 rows=0 loops=1)

  • Filter: ((endtime)::integer = ANY ('{1555142641}'::integer[]))
  • Rows Removed by Filter: 641429
  • Buffers: shared hit=118 read=108487