explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kdYZv

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 13,512.109 ↑ 1.0 300 1

Limit (cost=172,802.17..172,802.92 rows=300 width=32) (actual time=13,512.026..13,512.109 rows=300 loops=1)

  • Buffers: shared hit=1,629,346 read=778,160 dirtied=274 written=82,290
  • I/O Timings: read=9,062.750 write=686.528
2. 175.365 13,512.074 ↑ 23.3 300 1

Sort (cost=172,802.17..172,819.66 rows=6,998 width=32) (actual time=13,512.024..13,512.074 rows=300 loops=1)

  • Sort Key: sp.created_date
  • Sort Method: top-N heapsort Memory: 48kB
  • Buffers: shared hit=1,629,346 read=778,160 dirtied=274 written=82,290
  • I/O Timings: read=9,062.750 write=686.528
3. 81.060 13,336.709 ↓ 46.4 324,757 1

Nested Loop Semi Join (cost=1.15..172,479.25 rows=6,998 width=32) (actual time=0.076..13,336.709 rows=324,757 loops=1)

  • Buffers: shared hit=1,629,346 read=778,160 dirtied=274 written=82,290
  • I/O Timings: read=9,062.750 write=686.528
4. 8,622.233 8,622.233 ↓ 3.1 386,118 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.068..8,622.233 rows=386,118 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,883
  • Buffers: shared hit=32,403 read=386,295 dirtied=91 written=42,828
  • I/O Timings: read=7,145.867 write=358.948
5. 4,633.416 4,633.416 ↑ 23.0 1 386,118

Index Scan using shipment_package_items_shipment_package_id_index on shipment_package_items sit (cost=0.57..7.61 rows=23 width=8) (actual time=0.012..0.012 rows=1 loops=386,118)

  • Index Cond: (shipment_package_id = sp.id)
  • Filter: (shipment_package_item_status_id = ANY ('{1,51,101,151,251,301,351}'::integer[]))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,596,943 read=391,865 dirtied=183 written=39,462
  • I/O Timings: read=1,916.883 write=327.580
Planning time : 0.688 ms
Execution time : 13,512.162 ms