explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9p3S

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 99.737 ↑ 1.0 50 1

Limit (cost=57,123.25..57,123.38 rows=50 width=1,155) (actual time=99.704..99.737 rows=50 loops=1)

  • Buffers: shared hit=34359
2. 32.192 99.717 ↑ 732.6 50 1

Sort (cost=57,123.25..57,214.83 rows=36,630 width=1,155) (actual time=99.703..99.717 rows=50 loops=1)

  • Sort Key: bid_create_time DESC
  • Sort Method: top-N heapsort Memory: 50kB
  • Buffers: shared hit=34359
3. 67.525 67.525 ↑ 1.1 34,435 1

Index Scan using bid_sav_pk_create_time_index on bid_bids (cost=0.57..55,906.43 rows=36,630 width=1,155) (actual time=0.021..67.525 rows=34,435 loops=1)

  • Index Cond: (bid_sav_available_service_pk = ANY ('{214323469347144890,214308272978216026,214305925585462339,214292208020792501,214317098101171431,214328832794707154,214293525003019461,234185202356757509,213011260283520220,234270040938071050,214328191833457838,234238701010289904,212998542355768405,234105213938476277,214299325050725385,234247336488870913,214303401927074859,214318515121849348,234236203301479569,214295429850555611,214294856182973654,214354296356275240,214358554112787628,212943052065670168,214288316968485986,234183746316494059,214298492938519556,214297981434684667,213010912248521943}'::bigint[]))
  • Buffers: shared hit=34359
Planning time : 0.413 ms
Execution time : 99.816 ms