explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N9xB : live_delivery111

Settings
# exclusive inclusive rows x rows loops node
1. 0.114 2,905.610 ↑ 75.7 292 1

Append (cost=0.00..767,699.04 rows=22,105 width=1,177) (actual time=1,747.598..2,905.610 rows=292 loops=1)

  • Buffers: shared hit=152 read=701230 written=34
2. 33.181 33.181 ↓ 0.0 0 1

Seq Scan on delivery (cost=0.00..8,298.12 rows=1,464 width=80) (actual time=33.181..33.181 rows=0 loops=1)

  • Filter: ((endtime)::integer = 1555142641)
  • Rows Removed by Filter: 23096
  • Buffers: shared read=3905 written=29
3. 660.600 660.600 ↓ 0.0 0 1

Seq Scan on delivery_1554930000 (cost=0.00..170,134.91 rows=4,629 width=1,253) (actual time=660.600..660.600 rows=0 loops=1)

  • Filter: ((endtime)::integer = 1555142641)
  • Rows Removed by Filter: 926252
  • Buffers: shared read=156248 written=5
4. 643.268 643.268 ↓ 0.0 0 1

Seq Scan on delivery_1555016400 (cost=0.00..170,328.97 rows=4,638 width=1,253) (actual time=643.268..643.268 rows=0 loops=1)

  • Filter: ((endtime)::integer = 1555142641)
  • Rows Removed by Filter: 926610
  • Buffers: shared read=156415
5. 538.839 538.839 ↑ 14.2 292 1

Seq Scan on delivery_1555102800 (cost=0.00..152,882.10 rows=4,157 width=1,253) (actual time=410.541..538.839 rows=292 loops=1)

  • Filter: ((endtime)::integer = 1555142641)
  • Rows Removed by Filter: 831145
  • Buffers: shared read=140410
6. 578.770 578.770 ↓ 0.0 0 1

Seq Scan on delivery_1555189200 (cost=0.00..148,083.98 rows=4,017 width=1,258) (actual time=578.770..578.770 rows=0 loops=1)

  • Filter: ((endtime)::integer = 1555142641)
  • Rows Removed by Filter: 803676
  • Buffers: shared read=136034
7. 450.838 450.838 ↓ 0.0 0 1

Seq Scan on delivery_1555275600 (cost=0.00..117,970.96 rows=3,200 width=1,258) (actual time=450.838..450.838 rows=0 loops=1)

  • Filter: ((endtime)::integer = 1555142641)
  • Rows Removed by Filter: 640039
  • Buffers: shared hit=152 read=108218
Planning time : 1.988 ms
Execution time : 2,925.044 ms