explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bI0x

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=326,622.57..337,414.50 rows=12,315 width=672) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,622.57..335,183.00 rows=7,244 width=672) (actual rows= loops=)

  • Hash Cond: (fb.data_acquisition_source_dwid = ddas.data_acquisition_source_dwid)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,604.33..335,145.60 rows=7,244 width=669) (actual rows= loops=)

  • Hash Cond: (fb.device_platform_dwid = ddp.device_platform_dwid)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,587.21..335,109.31 rows=7,244 width=641) (actual rows= loops=)

  • Hash Cond: (fb.issuer_country_dwid = dc_i.country_dwid)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,573.56..335,076.32 rows=7,244 width=641) (actual rows= loops=)

  • Hash Cond: (fb.service_package_dwid = dsp.service_package_dwid)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,554.02..335,037.61 rows=7,244 width=639) (actual rows= loops=)

  • Hash Cond: (fb.fare_type_dwid = dft.fare_type_dwid)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=325,549.50..335,013.35 rows=7,244 width=637) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,549.07..331,824.10 rows=7,244 width=630) (actual rows= loops=)

  • Hash Cond: (fb.customer_nationality_dwid = dc_cn.country_dwid)
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,535.43..331,791.12 rows=7,244 width=631) (actual rows= loops=)

  • Hash Cond: (fb.beeline_dwid = db.beeline_dwid)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=325,520.78..331,757.28 rows=7,244 width=603) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,520.36..326,702.65 rows=11,481 width=596) (actual rows= loops=)

  • Hash Cond: (fb.price_category_per_passenger_dwid = dpc_pp.price_category_dwid)
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=325,505.71..326,657.57 rows=11,481 width=568) (actual rows= loops=)

  • Hash Cond: (fb.purchase_source_dwid = da_ps.application_dwid)
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=324,485.05..325,606.78 rows=11,481 width=554) (actual rows= loops=)

  • Hash Cond: (fb.return_window_dwid = dtw_r.time_window_dwid)
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=324,446.53..325,538.00 rows=11,481 width=554) (actual rows= loops=)

  • Hash Cond: (fb.booking_window_dwid = dtw_b.time_window_dwid)
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=324,408.01..325,469.22 rows=11,481 width=526) (actual rows= loops=)

  • Hash Cond: (fb.dst_transport_hub_dwid = dth_d.transport_hub_dwid)
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=323,630.95..324,662.02 rows=11,481 width=521) (actual rows= loops=)

  • Hash Cond: (fb.src_transport_hub_dwid = dth_s.transport_hub_dwid)
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=322,853.90..323,854.81 rows=11,481 width=516) (actual rows= loops=)

  • Hash Cond: (fb.device_type_dwid = ddt.device_type_dwid)
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=322,832.92..323,803.51 rows=11,481 width=488) (actual rows= loops=)

  • Hash Cond: (fb.price_category_dwid = dpc.price_category_dwid)
19. 0.000 0.000 ↓ 0.0

Hash Join (cost=322,818.28..323,758.44 rows=11,481 width=460) (actual rows= loops=)

  • Hash Cond: (fb.currency_dwid = dcur.currency_dwid)
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=322,812.16..323,721.48 rows=11,481 width=460) (actual rows= loops=)

  • Hash Cond: (fb.market_dwid = dc_m.country_dwid)
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=322,798.51..323,677.18 rows=11,481 width=461) (actual rows= loops=)

  • Hash Cond: (fb.trip_type_dwid = tt.trip_type_dwid)
22. 0.000 0.000 ↓ 0.0

Hash Join (cost=322,777.54..323,625.88 rows=11,481 width=433) (actual rows= loops=)

  • Hash Cond: (fb.content_type_dwid = ct.content_type_dwid)
23. 0.000 0.000 ↓ 0.0

Merge Join (cost=322,756.56..323,574.58 rows=11,481 width=405) (actual rows= loops=)

  • Merge Cond: (da.application_dwid = fb.application_dwid)
24. 0.000 0.000 ↓ 0.0

Parallel Index Scan using dim_application_pkey on dim_application da (cost=0.29..613.65 rows=14,407 width=22) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Sort (cost=322,756.27..322,805.07 rows=19,518 width=391) (actual rows= loops=)

  • Sort Key: fb.application_dwid
26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..321,365.37 rows=19,518 width=391) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using dim_booking_status_code_key on dim_booking_status bs (cost=0.15..0.57 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (code = 'unpaid'::text)
28. 0.000 0.000 ↓ 0.0

Index Scan using idx_view_booking_current_booking_status_dwid_old on view_booking_current fb (cost=0.43..302,962.17 rows=1,840,263 width=363) (actual rows= loops=)

  • Index Cond: (booking_status_dwid = bs.booking_status_dwid)
29. 0.000 0.000 ↓ 0.0

Hash (cost=12.60..12.60 rows=670 width=36) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Index Scan using dim_content_type_pkey on dim_content_type ct (cost=0.15..12.60 rows=670 width=36) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=12.60..12.60 rows=670 width=36) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using dim_trip_type_pkey on dim_trip_type tt (cost=0.15..12.60 rows=670 width=36) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=10.51..10.51 rows=251 width=7) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on dim_country dc_m (cost=0.00..10.51 rows=251 width=7) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash (cost=3.83..3.83 rows=183 width=8) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on dim_currency dcur (cost=0.00..3.83 rows=183 width=8) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=9.15..9.15 rows=440 width=36) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Index Scan using dim_price_category_pkey on dim_price_category dpc (cost=0.15..9.15 rows=440 width=36) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash (cost=12.60..12.60 rows=670 width=36) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Index Scan using dim_device_type_pkey on dim_device_type ddt (cost=0.15..12.60 rows=670 width=36) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash (cost=542.58..542.58 rows=18,758 width=13) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on dim_transport_hub dth_s (cost=0.00..542.58 rows=18,758 width=13) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash (cost=542.58..542.58 rows=18,758 width=13) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on dim_transport_hub dth_d (cost=0.00..542.58 rows=18,758 width=13) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Hash (cost=26.01..26.01 rows=1,001 width=36) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on dim_time_window dtw_b (cost=0.00..26.01 rows=1,001 width=36) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash (cost=26.01..26.01 rows=1,001 width=8) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on dim_time_window dtw_r (cost=0.00..26.01 rows=1,001 width=8) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Hash (cost=714.50..714.50 rows=24,492 width=22) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Index Scan using dim_application_pkey on dim_application da_ps (cost=0.29..714.50 rows=24,492 width=22) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Hash (cost=9.15..9.15 rows=440 width=36) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Index Scan using dim_price_category_pkey on dim_price_category dpc_pp (cost=0.15..9.15 rows=440 width=36) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Index Scan using dim_carrier_combo_pkey on dim_carrier_combo dcc_o (cost=0.42..0.44 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (carrier_combo_dwid = fb.original_carrier_combo_dwid)
54. 0.000 0.000 ↓ 0.0

Hash (cost=9.15..9.15 rows=440 width=36) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Index Scan using dim_beeline_pkey on dim_beeline db (cost=0.15..9.15 rows=440 width=36) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Hash (cost=10.51..10.51 rows=251 width=7) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on dim_country dc_cn (cost=0.00..10.51 rows=251 width=7) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Index Scan using dim_carrier_combo_pkey on dim_carrier_combo dcc (cost=0.42..0.44 rows=1 width=15) (actual rows= loops=)

  • Index Cond: (carrier_combo_dwid = fb.carrier_combo_dwid)
59. 0.000 0.000 ↓ 0.0

Hash (cost=3.12..3.12 rows=112 width=10) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on dim_fare_type dft (cost=0.00..3.12 rows=112 width=10) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Hash (cost=13.13..13.13 rows=513 width=10) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on dim_service_package dsp (cost=0.00..13.13 rows=513 width=10) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash (cost=10.51..10.51 rows=251 width=8) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on dim_country dc_i (cost=0.00..10.51 rows=251 width=8) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=530 width=36) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Index Scan using dim_device_platform_pkey on dim_device_platform ddp (cost=0.15..10.50 rows=530 width=36) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Hash (cost=11.44..11.44 rows=544 width=11) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on dim_data_acquisition_source ddas (cost=0.00..11.44 rows=544 width=11) (actual rows= loops=)