explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1yBj

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,906.553 ↑ 113.7 3 1

Sort (cost=640,845.33..640,846.18 rows=341 width=32) (actual time=1,906.553..1,906.553 rows=3 loops=1)

  • Sort Key: time_steps.start_time, time_steps.sequence_number, time_steps.contiguous_state
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6278 read=25686 dirtied=93 written=184
2.          

CTE time_steps

3. 0.010 1,906.496 ↑ 1.6 214 1

Append (cost=640,803.28..640,822.46 rows=341 width=32) (actual time=1,906.303..1,906.496 rows=214 loops=1)

  • Buffers: shared hit=6278 read=25686 dirtied=93 written=184
4. 0.113 1,906.410 ↑ 1.6 213 1

WindowAgg (cost=640,803.28..640,812.63 rows=340 width=32) (actual time=1,906.303..1,906.41 rows=213 loops=1)

  • Buffers: shared hit=6278 read=25680 dirtied=93 written=184
5. 0.099 1,906.297 ↑ 1.6 213 1

Sort (cost=640,803.28..640,804.13 rows=340 width=24) (actual time=1,906.291..1,906.297 rows=213 loops=1)

  • Sort Key: packet_entry.start_time, packet_entry.sequence_number DESC
  • Sort Method: quicksort Memory: 41kB
  • Buffers: shared hit=6278 read=25680 dirtied=93 written=184
6. 1,906.198 1,906.198 ↑ 1.6 213 1

Index Scan using packet_entry_pkey on packet_entry packet_entry (cost=0.69..640,788.98 rows=340 width=24) (actual time=1,904.869..1,906.198 rows=213 loops=1)

  • Index Cond: (((packet_entry.band_id)::text = 'titanEA-Slave_1004/band/timeSeries3'::text) AND (packet_entry.start_time >= '1559599888000000000'::bigint))
  • Filter: (packet_entry.contiguous_state <> 1)
  • Buffers: shared hit=6278 read=25680 dirtied=93 written=184
7. 0.001 0.076 ↑ 1.0 1 1

Limit (cost=0.69..4.71 rows=1 width=32) (actual time=0.076..0.076 rows=1 loops=1)

  • Buffers: shared read=6
8. 0.075 0.075 ↑ 159,232.0 1 1

Index Scan using packet_entry_pkey on packet_entry packet_entry_1 (cost=0.69..640,390.9 rows=159,232 width=32) (actual time=0.075..0.075 rows=1 loops=1)

  • Index Cond: (((packet_entry_1.band_id)::text = 'titanEA-Slave_1004/band/timeSeries3'::text) AND (packet_entry_1.start_time >= '1559599888000000000'::bigint))
  • Buffers: shared read=6
9. 1,906.548 1,906.548 ↑ 113.7 3 1

CTE Scan on time_steps time_steps (cost=0..8.53 rows=341 width=32) (actual time=1,906.306..1,906.548 rows=3 loops=1)

  • Filter: ((time_steps.prev_step IS NULL) OR (time_steps.prev_step <> 1) OR (time_steps.next_step IS NULL) OR (time_steps.next_step <> 1))
  • Buffers: shared hit=6278 read=25686 dirtied=93 written=184