explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JruR

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 756.161 ↑ 1.0 300 1

Limit (cost=66,166.26..66,167.01 rows=300 width=32) (actual time=756.111..756.161 rows=300 loops=1)

  • Buffers: shared hit=418,067 read=242
  • I/O Timings: read=2.693
2. 113.972 756.132 ↑ 417.3 300 1

Sort (cost=66,166.26..66,479.27 rows=125,204 width=32) (actual time=756.109..756.132 rows=300 loops=1)

  • Sort Key: created_date
  • Sort Method: top-N heapsort Memory: 48kB
  • Buffers: shared hit=418,067 read=242
  • I/O Timings: read=2.693
3. 642.160 642.160 ↓ 3.1 386,029 1

Index Scan using idx_channel_id on shipment_packages sp (cost=0.57..60,388.84 rows=125,204 width=32) (actual time=0.022..642.160 rows=386,029 loops=1)

  • Index Cond: (channel_id = 3)
  • Filter: ((created_date > '1970-01-01 00:00:00'::timestamp without time zone) AND (created_date >= '2020-05-29 00:00:00'::timestamp without time zone) AND (created_date <= '2020-10-20 00:00:00'::timestamp without time zone) AND (type = 51))
  • Rows Removed by Filter: 7,881
  • Buffers: shared hit=418,067 read=242
  • I/O Timings: read=2.693
Planning time : 0.271 ms
Execution time : 756.210 ms