explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QL2S

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 11.288 ↑ 1.0 50 1

Limit (cost=2,639.74..2,639.87 rows=50 width=714) (actual time=11.217..11.288 rows=50 loops=1)

2. 1.055 11.235 ↑ 30.0 50 1

Sort (cost=2,639.74..2,643.49 rows=1,500 width=714) (actual time=11.216..11.235 rows=50 loops=1)

  • Sort Key: bid_bids.bid_create_time
  • Sort Method: top-N heapsort Memory: 118kB
3. 4.202 10.180 ↑ 1.5 1,031 1

HashAggregate (cost=2,574.91..2,589.91 rows=1,500 width=714) (actual time=9.324..10.180 rows=1,031 loops=1)

  • Group Key: bid_bids.bid_bid_id, bid_bids.bid_usr_user_id, bid_bids.bid_req_request_id, bid_bids.bid_sav_available_service_id, bid_bids.bid_url_code, bid_bids.bid_create_time, bid_bids.bid_status, bid_bids.bid_flags, bid_bids.bid_sherpas, bid_bids.bid_sherpas_skipped, bid_bids.bid_fee_status, bid_bids.bid_fee_payment_time, bid_bids.bid_buyer_last_seen_time, bid_bids.bid_seller_last_seen_time, bid_bids.bid_last_activity_time, bid_bids.bid_last_message_time, bid_bids.bid_estimate_type, bid_bids.bid_estimate_unit_name, bid_bids.bid_estimate_unit_quantity, bid_bids.bid_estimate_price_per_unit, bid_bids.bid_estimate_notes, bid_bids.bid_lead_cost_reason, bid_bids.bid_sent_time, bid_bids.bid_review_ask_time, bid_bids.bid_review_ask_time_type, bid_bids.bid_archive_time, bid_bids.bid_unarchive_time, bid_bids.bid_buyer_first_seen_time, bid_bids.bid_seller_first_seen_time, bid_bids.bid_profile_view_time, bid_bids.bid_website_view_time, bid_bids.bid_refund_time, bid_bids.bid_refund_note, bid_bids.bid_buyer_last_activity_time, bid_bids.bid_estimate_time, bid_bids.bid_status_time, bid_bids.bid_status_usr_user_id, bid_bids.bid_message, bid_bids.bid_attachments, bid_bids.bid_rca_request_category_id, bid_bids.bid_num_credits, bid_bids.bid_type, bid_bids.bid_template_id, bid_bids.bid_pay_per_customer_contact, bid_bids.bid_seller_report_time, bid_bids.bid_unseen_events_consumer, bid_bids.bid_unseen_events_pro, bid_bids.bid_buyer_seen_for_refund_time, bid_bids.bid_pay_per_autopay, bid_bids.bid_bid_pk, bid_bids.bid_view_status, bid_bids.bid_pro_inbox_sort_time, bid_bids.bid_buyer_name, bid_bids.bid_progress_status, bid_bids.bid_num_cents, bid_bids.bid_buyer_report_time, bid_bids.bid_incontext_feedback_type, bid_bids.bid_syndication_type, bid_bids.bid_syndication_rca_request_category_id, bid_bids.bid_usr_user_pk, bid_bids.bid_status_usr_user_pk, bid_bids.bid_req_request_pk, bid_bids.bid_sav_available_service_pk, bid_bids.bid_rca_request_category_pk, bid_bids.bid_syndication_rca_request_category_pk, bid_bids.bid_thread_pk, bid_bids.bid_intro_type
4. 0.381 5.978 ↑ 1.4 1,081 1

Append (cost=0.57..2,323.66 rows=1,500 width=714) (actual time=0.023..5.978 rows=1,081 loops=1)

5. 0.017 0.156 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.023..0.156 rows=50 loops=1)

6. 0.139 0.139 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.023..0.139 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214323469347144890'::bigint)
7. 0.018 0.128 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.013..0.128 rows=50 loops=1)

8. 0.110 0.110 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_1 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.011..0.110 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214308272978216026'::bigint)
9. 0.017 0.377 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.034..0.377 rows=50 loops=1)

10. 0.360 0.360 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_2 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.032..0.360 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214305925585462339'::bigint)
11. 0.017 0.335 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.032..0.335 rows=50 loops=1)

12. 0.318 0.318 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_3 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.031..0.318 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214292208020792501'::bigint)
13. 0.010 0.097 ↑ 3.3 15 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.025..0.097 rows=15 loops=1)

14. 0.087 0.087 ↑ 84.2 15 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_4 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.023..0.087 rows=15 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214317098101171431'::bigint)
15. 0.014 0.316 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.024..0.316 rows=50 loops=1)

16. 0.302 0.302 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_5 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.024..0.302 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214328832794707154'::bigint)
17. 0.002 0.120 ↑ 2.6 19 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.019..0.120 rows=19 loops=1)

18. 0.118 0.118 ↑ 66.5 19 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_6 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.019..0.118 rows=19 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214293525003019461'::bigint)
19. 0.019 0.323 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.041..0.323 rows=50 loops=1)

20. 0.304 0.304 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_7 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.040..0.304 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234185202356757509'::bigint)
21. 0.001 0.035 ↑ 16.7 3 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.022..0.035 rows=3 loops=1)

22. 0.034 0.034 ↑ 421.0 3 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_8 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.021..0.034 rows=3 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '213011260283520220'::bigint)
23. 0.001 0.057 ↑ 8.3 6 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.030..0.057 rows=6 loops=1)

24. 0.056 0.056 ↑ 210.5 6 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_9 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.029..0.056 rows=6 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234270040938071050'::bigint)
25. 0.016 0.279 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.021..0.279 rows=50 loops=1)

26. 0.263 0.263 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_10 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.019..0.263 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214328191833457838'::bigint)
27. 0.036 0.298 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.027..0.298 rows=50 loops=1)

28. 0.262 0.262 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_11 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.026..0.262 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234238701010289904'::bigint)
29. 0.022 0.253 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.018..0.253 rows=50 loops=1)

30. 0.231 0.231 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_12 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.017..0.231 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '212998542355768405'::bigint)
31. 0.017 0.197 ↑ 1.2 42 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.016..0.197 rows=42 loops=1)

32. 0.180 0.180 ↑ 30.1 42 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_13 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.014..0.180 rows=42 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234105213938476277'::bigint)
33. 0.024 0.271 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.025..0.271 rows=50 loops=1)

34. 0.247 0.247 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_14 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.023..0.247 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214299325050725385'::bigint)
35. 0.006 0.044 ↑ 7.1 7 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.018..0.044 rows=7 loops=1)

36. 0.038 0.038 ↑ 180.4 7 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_15 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.018..0.038 rows=7 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234247336488870913'::bigint)
37. 0.019 0.285 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.020..0.285 rows=50 loops=1)

38. 0.266 0.266 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_16 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.019..0.266 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214303401927074859'::bigint)
39. 0.019 0.235 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.020..0.235 rows=50 loops=1)

40. 0.216 0.216 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_17 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.018..0.216 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214318515121849348'::bigint)
41. 0.020 0.216 ↑ 1.1 47 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.014..0.216 rows=47 loops=1)

42. 0.196 0.196 ↑ 26.9 47 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_18 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.012..0.196 rows=47 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234236203301479569'::bigint)
43. 0.020 0.255 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.015..0.255 rows=50 loops=1)

44. 0.235 0.235 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_19 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.014..0.235 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214295429850555611'::bigint)
45. 0.003 0.017 ↑ 50.0 1 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.016..0.017 rows=1 loops=1)

46. 0.014 0.014 ↑ 1,263.0 1 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_20 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214294856182973654'::bigint)
47. 0.001 0.064 ↑ 5.6 9 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.024..0.064 rows=9 loops=1)

48. 0.063 0.063 ↑ 140.3 9 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_21 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.024..0.063 rows=9 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214354296356275240'::bigint)
49. 0.023 0.228 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.010..0.228 rows=50 loops=1)

50. 0.205 0.205 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_22 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.009..0.205 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214358554112787628'::bigint)
51. 0.005 0.082 ↑ 2.8 18 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.014..0.082 rows=18 loops=1)

52. 0.077 0.077 ↑ 70.2 18 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_23 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.014..0.077 rows=18 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '212943052065670168'::bigint)
53. 0.000 0.046 ↑ 5.6 9 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.017..0.046 rows=9 loops=1)

54. 0.046 0.046 ↑ 140.3 9 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_24 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.017..0.046 rows=9 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214288316968485986'::bigint)
55. 0.021 0.226 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.017..0.226 rows=50 loops=1)

56. 0.205 0.205 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_25 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.016..0.205 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '234183746316494059'::bigint)
57. 0.024 0.249 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.022..0.249 rows=50 loops=1)

58. 0.225 0.225 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_26 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.021..0.225 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214298492938519556'::bigint)
59. 0.017 0.242 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.018..0.242 rows=50 loops=1)

60. 0.225 0.225 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_27 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.017..0.225 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214297981434684667'::bigint)
61. 0.003 0.036 ↑ 10.0 5 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.025..0.036 rows=5 loops=1)

62. 0.033 0.033 ↑ 252.6 5 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_28 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.024..0.033 rows=5 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '213010912248521943'::bigint)
63. 0.015 0.130 ↑ 1.0 50 1

Limit (cost=0.57..76.96 rows=50 width=1,156) (actual time=0.012..0.130 rows=50 loops=1)

64. 0.115 0.115 ↑ 25.3 50 1

Index Scan using bid_sav_pk_create_time_index on bid_bids bid_bids_29 (cost=0.57..1,930.13 rows=1,263 width=1,156) (actual time=0.011..0.115 rows=50 loops=1)

  • Index Cond: (bid_sav_available_service_pk = '214308272978216026'::bigint)
Planning time : 5.199 ms
Execution time : 12.841 ms