explain.depesz.com

PostgreSQL's explain analyze made readable

Result: thlqF

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 73.205 ↑ 1.0 5 1

Nested Loop Left Join (cost=10.42..74.84 rows=5 width=7,804) (actual time=9.180..73.205 rows=5 loops=1)

2. 0.033 73.137 ↑ 1.0 5 1

Nested Loop Left Join (cost=10.28..73.40 rows=5 width=7,637) (actual time=9.158..73.137 rows=5 loops=1)

3. 0.034 73.074 ↑ 1.0 5 1

Nested Loop Left Join (cost=10.13..72.04 rows=5 width=7,578) (actual time=9.142..73.074 rows=5 loops=1)

4. 0.032 72.965 ↑ 1.0 5 1

Nested Loop Left Join (cost=9.85..69.68 rows=5 width=7,295) (actual time=9.102..72.965 rows=5 loops=1)

5. 0.039 70.088 ↑ 1.0 5 1

Nested Loop Left Join (cost=9.42..66.58 rows=5 width=7,119) (actual time=9.091..70.088 rows=5 loops=1)

6. 0.043 70.044 ↑ 1.0 5 1

Nested Loop Left Join (cost=9.14..64.19 rows=5 width=6,971) (actual time=9.080..70.044 rows=5 loops=1)

7. 0.026 61.716 ↑ 1.0 5 1

Nested Loop Left Join (cost=8.57..60.39 rows=5 width=6,284) (actual time=8.303..61.716 rows=5 loops=1)

8. 0.035 61.685 ↑ 1.0 5 1

Nested Loop Left Join (cost=8.00..56.58 rows=5 width=5,597) (actual time=8.294..61.685 rows=5 loops=1)

9. 0.032 61.645 ↑ 1.0 5 1

Nested Loop Left Join (cost=7.57..53.46 rows=5 width=5,420) (actual time=8.285..61.645 rows=5 loops=1)

10. 0.040 58.293 ↑ 1.0 5 1

Nested Loop Left Join (cost=7.14..50.34 rows=5 width=5,243) (actual time=7.610..58.293 rows=5 loops=1)

11. 0.036 58.238 ↑ 1.0 5 1

Nested Loop Left Join (cost=6.71..47.22 rows=5 width=5,066) (actual time=7.600..58.238 rows=5 loops=1)

12. 0.018 50.212 ↑ 1.0 5 1

Nested Loop Left Join (cost=6.28..44.10 rows=5 width=4,889) (actual time=6.836..50.212 rows=5 loops=1)

13. 0.027 50.189 ↑ 1.0 5 1

Nested Loop Left Join (cost=5.85..40.98 rows=5 width=4,712) (actual time=6.832..50.189 rows=5 loops=1)

14. 0.022 50.152 ↑ 1.0 5 1

Nested Loop Left Join (cost=5.42..37.86 rows=5 width=4,535) (actual time=6.828..50.152 rows=5 loops=1)

15. 0.022 50.130 ↑ 1.0 5 1

Nested Loop Left Join (cost=4.99..34.74 rows=5 width=4,358) (actual time=6.824..50.130 rows=5 loops=1)

16. 0.028 50.108 ↑ 1.0 5 1

Nested Loop Left Join (cost=4.56..31.62 rows=5 width=4,181) (actual time=6.819..50.108 rows=5 loops=1)

17. 0.036 50.075 ↑ 1.0 5 1

Nested Loop Left Join (cost=3.99..27.78 rows=5 width=3,839) (actual time=6.812..50.075 rows=5 loops=1)

18. 0.041 38.029 ↑ 1.0 5 1

Nested Loop Left Join (cost=3.42..23.96 rows=5 width=3,576) (actual time=4.666..38.029 rows=5 loops=1)

19. 0.023 25.548 ↑ 1.0 5 1

Nested Loop Left Join (cost=2.85..20.15 rows=5 width=2,786) (actual time=4.436..25.548 rows=5 loops=1)

20. 0.032 25.525 ↑ 1.0 5 1

Nested Loop (cost=2.29..16.34 rows=5 width=1,996) (actual time=4.430..25.525 rows=5 loops=1)

21. 0.029 25.443 ↑ 1.0 5 1

Nested Loop (cost=2.14..14.82 rows=5 width=724) (actual time=4.400..25.443 rows=5 loops=1)

22. 0.020 15.764 ↑ 1.0 5 1

Nested Loop (cost=1.57..10.99 rows=5 width=336) (actual time=3.483..15.764 rows=5 loops=1)

23. 0.027 3.614 ↑ 1.0 5 1

Nested Loop (cost=1.00..7.17 rows=5 width=16) (actual time=0.870..3.614 rows=5 loops=1)

24. 0.232 0.232 ↑ 1.0 5 1

Index Scan using deals_pkey on deals cd (cost=0.43..3.20 rows=5 width=8) (actual time=0.073..0.232 rows=5 loops=1)

  • Index Cond: (deal_id = ANY ('{1414729,1384152,1364805,1351167,1348935}'::bigint[]))
25. 3.355 3.355 ↑ 1.0 1 5

Index Scan using listing_id_available_photos on listings dl (cost=0.57..0.79 rows=1 width=24) (actual time=0.671..0.671 rows=1 loops=5)

  • Index Cond: (listing_id = cd.listing_id)
26. 12.130 12.130 ↑ 1.0 1 5

Index Scan using search_keys_pkey on search_keys sk (cost=0.57..0.75 rows=1 width=320) (actual time=2.425..2.426 rows=1 loops=5)

  • Index Cond: (property_id = dl.property_id)
27. 9.650 9.650 ↑ 1.0 1 5

Index Scan using properties_pkey on properties p (cost=0.57..0.75 rows=1 width=396) (actual time=1.929..1.930 rows=1 loops=5)

  • Index Cond: (property_id = sk.property_id)
28. 0.050 0.050 ↑ 1.0 1 5

Index Scan using data_sources_pkey on data_sources lds (cost=0.15..0.30 rows=1 width=1,280) (actual time=0.009..0.010 rows=1 loops=5)

  • Index Cond: (data_source_id = dl.data_source_id)
29. 0.000 0.000 ↓ 0.0 0 5

Index Scan using listings_pkey on listings l (cost=0.57..0.75 rows=1 width=790) (actual time=0.000..0.000 rows=0 loops=5)

  • Index Cond: (sk.listing_id = listing_id)
30. 12.440 12.440 ↑ 1.0 1 5

Index Scan using listings_pkey on listings sl (cost=0.57..0.75 rows=1 width=790) (actual time=2.487..2.488 rows=1 loops=5)

  • Index Cond: (sk.sale_listing_id = listing_id)
31. 12.010 12.010 ↑ 1.0 1 5

Index Scan using shared_property_notes_visibilities_pkey on shared_property_notes_visibilities spnv (cost=0.57..0.75 rows=1 width=263) (actual time=1.736..2.402 rows=1 loops=5)

  • Index Cond: (sk.property_id = property_id)
32. 0.005 0.005 ↓ 0.0 0 5

Index Scan using property_transactions_pkey on property_transactions pt (cost=0.57..0.76 rows=1 width=342) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (sk.property_transaction_id = property_transaction_id)
33. 0.000 0.000 ↓ 0.0 0 5

Index Scan using listing_brokers_pkey on listing_brokers lb (cost=0.43..0.61 rows=1 width=177) (actual time=0.000..0.000 rows=0 loops=5)

  • Index Cond: (listing_broker_id = l.listing_broker_id)
34. 0.000 0.000 ↓ 0.0 0 5

Index Scan using listing_brokers_pkey on listing_brokers lcb (cost=0.43..0.61 rows=1 width=177) (actual time=0.000..0.000 rows=0 loops=5)

  • Index Cond: (listing_broker_id = l.listing_co_broker_id)
35. 0.010 0.010 ↓ 0.0 0 5

Index Scan using listing_brokers_pkey on listing_brokers sb (cost=0.43..0.61 rows=1 width=177) (actual time=0.002..0.002 rows=0 loops=5)

  • Index Cond: (listing_broker_id = l.selling_broker_id)
36. 0.005 0.005 ↓ 0.0 0 5

Index Scan using listing_brokers_pkey on listing_brokers scb (cost=0.43..0.61 rows=1 width=177) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (listing_broker_id = l.selling_co_broker_id)
37. 7.990 7.990 ↑ 1.0 1 5

Index Scan using listing_brokers_pkey on listing_brokers slb (cost=0.43..0.61 rows=1 width=177) (actual time=1.598..1.598 rows=1 loops=5)

  • Index Cond: (listing_broker_id = sl.listing_broker_id)
38. 0.015 0.015 ↓ 0.0 0 5

Index Scan using listing_brokers_pkey on listing_brokers slcb (cost=0.43..0.61 rows=1 width=177) (actual time=0.003..0.003 rows=0 loops=5)

  • Index Cond: (listing_broker_id = sl.listing_co_broker_id)
39. 3.320 3.320 ↑ 1.0 1 5

Index Scan using listing_brokers_pkey on listing_brokers ssb (cost=0.43..0.61 rows=1 width=177) (actual time=0.663..0.664 rows=1 loops=5)

  • Index Cond: (listing_broker_id = sl.selling_broker_id)
40. 0.005 0.005 ↓ 0.0 0 5

Index Scan using listing_brokers_pkey on listing_brokers sscb (cost=0.43..0.61 rows=1 width=177) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (listing_broker_id = sl.selling_co_broker_id)
41. 0.005 0.005 ↓ 0.0 0 5

Index Scan using listing_display_info_pkey on listing_display_info ldi (cost=0.57..0.75 rows=1 width=687) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (listing_id = l.listing_id)
42. 8.285 8.285 ↑ 1.0 1 5

Index Scan using listing_display_info_pkey on listing_display_info sldi (cost=0.57..0.75 rows=1 width=687) (actual time=1.657..1.657 rows=1 loops=5)

  • Index Cond: (listing_id = sl.listing_id)
43. 0.005 0.005 ↓ 0.0 0 5

Index Scan using visibility_profiles_pkey on visibility_profiles vp (cost=0.29..0.47 rows=1 width=148) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (l.visibility_profile_id = visibility_profile_id)
44. 2.845 2.845 ↓ 0.0 0 5

Index Scan using editable_home_facts_pkey on editable_home_facts ehf (cost=0.42..0.61 rows=1 width=176) (actual time=0.569..0.569 rows=0 loops=5)

  • Index Cond: (sk.editable_home_fact_id = editable_home_fact_id)
45. 0.075 0.075 ↑ 1.0 1 5

Index Scan using service_regions_pkey on service_regions sr (cost=0.28..0.46 rows=1 width=283) (actual time=0.015..0.015 rows=1 loops=5)

  • Index Cond: (sk.service_region_id = service_region_id)
46. 0.030 0.030 ↑ 1.0 1 5

Index Scan using business_areas_pkey on business_areas ba (cost=0.14..0.26 rows=1 width=59) (actual time=0.005..0.006 rows=1 loops=5)

  • Index Cond: (sr.business_area_id = business_area_id)
47. 0.030 0.030 ↑ 1.0 1 5

Index Scan using business_markets_pkey on business_markets bm (cost=0.14..0.28 rows=1 width=167) (actual time=0.005..0.006 rows=1 loops=5)

  • Index Cond: (ba.business_market_id = business_market_id)
Planning time : 164.438 ms