explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WB9A

Settings
# exclusive inclusive rows x rows loops node
1. 1.753 2,734.576 ↓ 854.0 854 1

-------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop (cost=19,045.71..19,188.14 rows=1 width=145) (actual time=2,720.120..2,734.576 rows=854 loops=1)

2.          

CTE base_listing_ids

3. 0.099 39.230 ↓ 1,000.0 1,000 1

Limit (cost=26.22..388.40 rows=1 width=12) (actual time=0.595..39.230 rows=1,000 loops=1)

4. 0.262 39.131 ↓ 1,000.0 1,000 1

Nested Loop (cost=26.22..388.40 rows=1 width=12) (actual time=0.594..39.131 rows=1,000 loops=1)

  • Join Filter: (tag_aggregate.model_id = model.id)
  • Rows Removed by Join Filter: 719
5. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on model (cost=0.00..1.05 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: (enabled AND (label = 'new_program_tagger'::text))
  • Rows Removed by Filter: 2
6. 0.309 38.862 ↓ 859.5 1,719 1

Nested Loop (cost=26.22..387.32 rows=2 width=20) (actual time=0.587..38.862 rows=1,719 loops=1)

  • Join Filter: (tag_aggregate.tag_id = tag.id)
  • Rows Removed by Join Filter: 342
7. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on tag (cost=0.00..1.06 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (enabled AND (label = 'TAGGING.OLD'::text))
  • Rows Removed by Filter: 1
8. 1.179 38.550 ↓ 229.0 2,061 1

Nested Loop (cost=26.22..386.15 rows=9 width=28) (actual time=0.583..38.550 rows=2,061 loops=1)

9. 0.151 19.191 ↓ 168.3 1,010 1

Nested Loop (cost=25.66..337.94 rows=6 width=12) (actual time=0.552..19.191 rows=1,010 loops=1)

10. 0.022 0.452 ↓ 4.0 4 1

HashAggregate (cost=25.23..25.24 rows=1 width=8) (actual time=0.445..0.452 rows=4 loops=1)

  • Group Key: cities.id
11. 0.015 0.430 ↓ 30.0 30 1

Nested Loop (cost=1.16..25.23 rows=1 width=8) (actual time=0.086..0.430 rows=30 loops=1)

12. 0.010 0.145 ↓ 30.0 30 1

Nested Loop (cost=0.86..16.91 rows=1 width=4) (actual time=0.064..0.145 rows=30 loops=1)

13. 0.075 0.075 ↓ 30.0 30 1

Index Scan using geo_link_type_id1_id2 on geo_link (cost=0.57..8.59 rows=1 width=8) (actual time=0.049..0.075 rows=30 loops=1)

  • Index Cond: ((type = 1,718,768,002) AND (id1 = 2,080,777,928))
  • Filter: enabled
14. 0.060 0.060 ↑ 1.0 1 30

Index Scan using geo_place2_pkey on geo_place2 places_1 (cost=0.29..8.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=30)

  • Index Cond: (id = 2,080,777,928)
  • Filter: (enabled AND active AND (type = 100))
15. 0.270 0.270 ↑ 1.0 1 30

Index Scan using geo_place2_pkey on geo_place2 cities (cost=0.29..8.31 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=30)

  • Index Cond: (id = geo_link.id2)
  • Filter: (enabled AND active AND (type = 40))
16. 18.588 18.588 ↓ 42.0 252 4

Index Scan using aggregate_rental_source_transac_type_item_type_city_id_idx on aggregate_rental (cost=0.43..312.64 rows=6 width=12) (actual time=0.115..4.647 rows=252 loops=4)

  • Index Cond: ((source = 64,760,812) AND (transaction_type = 369,681,778) AND (item_type = 369,681,781) AND (city_id = cities.id))
  • Filter: ((bathroom_count IS NOT NULL) AND (floor IS NOT NULL) AND (floor_count IS NOT NULL) AND enabled AND (room_count > 0) AND (area >= 4) AND (area <= 500) AND (current_price > 0) AND (start_date >= '2017-01-01'::date) AND (start_date <= '2020-08-01'::date))
  • Rows Removed by Filter: 528
17. 18.180 18.180 ↓ 2.0 2 1,010

Index Scan using listing_tag_aggregate_listing_id_model_id on tag_aggregate (cost=0.56..8.03 rows=1 width=24) (actual time=0.012..0.018 rows=2 loops=1,010)

  • Index Cond: (listing_id = aggregate_rental.id)
18.          

CTE geoloc_address_level

19. 0.006 0.006 ↑ 1.0 2 1

Values Scan on "*VALUES*" (cost=0.00..0.03 rows=2 width=8) (actual time=0.005..0.006 rows=2 loops=1)

20.          

CTE block_from_address

21. 0.413 55.083 ↓ 537.0 537 1

Nested Loop (cost=1.59..27.02 rows=1 width=32) (actual time=0.699..55.083 rows=537 loops=1)

  • Join Filter: (geoloc_address.model_id = geoloc_address_level.model_id)
  • Rows Removed by Join Filter: 537
22. 0.062 54.670 ↓ 537.0 537 1

Nested Loop (cost=1.59..26.95 rows=1 width=32) (actual time=0.692..54.670 rows=537 loops=1)

23. 0.431 53.534 ↓ 537.0 537 1

Nested Loop (cost=1.29..20.97 rows=1 width=32) (actual time=0.682..53.534 rows=537 loops=1)

24. 0.426 52.029 ↓ 537.0 537 1

Nested Loop (cost=0.87..14.84 rows=1 width=32) (actual time=0.664..52.029 rows=537 loops=1)

25. 0.338 48.918 ↓ 537.0 537 1

Nested Loop (cost=0.43..8.48 rows=1 width=28) (actual time=0.629..48.918 rows=537 loops=1)

26. 39.580 39.580 ↓ 1,000.0 1,000 1

CTE Scan on base_listing_ids (cost=0.00..0.02 rows=1 width=12) (actual time=0.596..39.580 rows=1,000 loops=1)

27. 9.000 9.000 ↑ 1.0 1 1,000

Index Scan using geoloc_address_aggregate_listing_id_address_id_model_id_idx on geoloc_address_aggregate geoloc_address (cost=0.43..8.45 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=1,000)

  • Index Cond: (listing_id = base_listing_ids.listing_id)
  • Filter: ((model_id = ANY ('{2004531438,2025990554}'::integer[])) AND (accuracy > '0.8'::double precision))
28. 2.685 2.685 ↑ 1.0 1 537

Index Scan using geo_address2_pkey on geo_address2 address_ref (cost=0.44..6.35 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=537)

  • Index Cond: (id = geoloc_address.address_id)
  • Filter: enabled
29. 1.074 1.074 ↑ 1.0 1 537

Index Scan using geo_block2_pkey on geo_block2 gb (cost=0.43..6.13 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=537)

  • Index Cond: (id = address_ref.block_id)
  • Filter: enabled
30. 1.074 1.074 ↑ 1.0 1 537

Index Scan using geo_place2_pkey on geo_place2 gp (cost=0.29..5.98 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=537)

  • Index Cond: (id = address_ref.iris_id)
  • Filter: (enabled AND (type = 65))
31. 0.000 0.000 ↑ 1.0 2 537

CTE Scan on geoloc_address_level (cost=0.00..0.04 rows=2 width=8) (actual time=0.000..0.000 rows=2 loops=537)

32.          

CTE distinct_block_from_address

33. 0.088 55.619 ↓ 537.0 537 1

Unique (cost=0.03..0.04 rows=1 width=32) (actual time=55.488..55.619 rows=537 loops=1)

34. 0.261 55.531 ↓ 537.0 537 1

Sort (cost=0.03..0.04 rows=1 width=32) (actual time=55.487..55.531 rows=537 loops=1)

  • Sort Key: block_from_address.listing_id, block_from_address.geo_rank, block_from_address.accuracy DESC
  • Sort Method: quicksort Memory: 66kB
35. 55.270 55.270 ↓ 537.0 537 1

CTE Scan on block_from_address (cost=0.00..0.02 rows=1 width=32) (actual time=0.700..55.270 rows=537 loops=1)

36.          

CTE block_from_parcel

37. 0.023 68.921 ↓ 59.0 59 1

Nested Loop (cost=1.86..277.14 rows=1 width=20) (actual time=1.661..68.921 rows=59 loops=1)

38. 0.052 68.780 ↓ 59.0 59 1

Nested Loop (cost=1.57..269.18 rows=1 width=20) (actual time=1.650..68.780 rows=59 loops=1)

39. 0.041 68.610 ↓ 59.0 59 1

Nested Loop (cost=1.14..261.08 rows=1 width=20) (actual time=1.639..68.610 rows=59 loops=1)

40. 0.227 68.333 ↓ 59.0 59 1

Nested Loop (cost=0.57..252.82 rows=1 width=16) (actual time=1.624..68.333 rows=59 loops=1)

41. 28.987 61.161 ↓ 463.0 463 1

Nested Loop Anti Join (cost=0.00..0.05 rows=1 width=12) (actual time=0.324..61.161 rows=463 loops=1)

  • Join Filter: (base_listing_ids_1.listing_id = deja_geoloc.listing_id)
  • Rows Removed by Join Filter: 392,547
42. 0.174 0.174 ↓ 1,000.0 1,000 1

CTE Scan on base_listing_ids base_listing_ids_1 (cost=0.00..0.02 rows=1 width=12) (actual time=0.000..0.174 rows=1,000 loops=1)

43. 32.000 32.000 ↓ 393.0 393 1,000

CTE Scan on distinct_block_from_address deja_geoloc (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.032 rows=393 loops=1,000)

44. 6.945 6.945 ↓ 0.0 0 463

Index Only Scan using geoloc_parcel_aggregate_listing_id_parcel_id_model_id_idx on geoloc_parcel_aggregate geoloc_parcelle (cost=0.57..252.54 rows=23 width=12) (actual time=0.015..0.015 rows=0 loops=463)

  • Index Cond: (listing_id = base_listing_ids_1.listing_id)
  • Filter: (model_id = ANY ('{2002865338,2041672199}'::integer[]))
  • Rows Removed by Filter: 69
  • Heap Fetches: 363
45. 0.236 0.236 ↑ 1.0 1 59

Index Scan using geo_parcelle2_pkey on geo_parcelle2 parcelle_ref (cost=0.57..8.27 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=59)

  • Index Cond: (id = geoloc_parcelle.parcel_id)
  • Filter: enabled
46. 0.118 0.118 ↑ 1.0 1 59

Index Scan using geo_block2_pkey on geo_block2 gb_1 (cost=0.43..8.10 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=59)

  • Index Cond: (id = parcelle_ref.block_id)
  • Filter: enabled
47. 0.118 0.118 ↑ 1.0 1 59

Index Scan using geo_place2_pkey on geo_place2 gp_1 (cost=0.29..7.96 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=59)

  • Index Cond: (id = parcelle_ref.iris_id)
  • Filter: (enabled AND (type = 65))
48.          

CTE union_all_listings

49. 0.135 125.172 ↓ 298.0 596 1

Unique (cost=0.07..0.11 rows=2 width=28) (actual time=125.005..125.172 rows=596 loops=1)

50. 0.263 125.037 ↓ 298.0 596 1

Sort (cost=0.07..0.08 rows=2 width=28) (actual time=125.004..125.037 rows=596 loops=1)

  • Sort Key: distinct_block_from_address.listing_id, distinct_block_from_address.block_id, (1), distinct_block_from_address.iris_id, (1), distinct_block_from_address.city_id
  • Sort Method: quicksort Memory: 71kB
51. 0.062 124.774 ↓ 298.0 596 1

Append (cost=0.00..0.06 rows=2 width=28) (actual time=55.490..124.774 rows=596 loops=1)

52. 55.760 55.760 ↓ 537.0 537 1

CTE Scan on distinct_block_from_address (cost=0.00..0.02 rows=1 width=28) (actual time=55.490..55.760 rows=537 loops=1)

53. 68.952 68.952 ↓ 59.0 59 1

CTE Scan on block_from_parcel (cost=0.00..0.02 rows=1 width=28) (actual time=1.662..68.952 rows=59 loops=1)

54.          

CTE base_geoloc_parcelle_fuzzy

55. 18.087 158.979 ↓ 30,627.0 30,627 1

Nested Loop (cost=1.14..18,318.90 rows=1 width=20) (actual time=0.378..158.979 rows=30,627 loops=1)

56. 3.855 79.638 ↓ 30,627.0 30,627 1

Nested Loop (cost=0.57..18,310.67 rows=1 width=20) (actual time=0.363..79.638 rows=30,627 loops=1)

57. 30.670 62.855 ↓ 404.0 404 1

Nested Loop Anti Join (cost=0.00..0.08 rows=1 width=8) (actual time=0.342..62.855 rows=404 loops=1)

  • Join Filter: (union_all_listings.listing_id = base_listing_ids_2.listing_id)
  • Rows Removed by Join Filter: 418,094
58. 0.185 0.185 ↓ 1,000.0 1,000 1

CTE Scan on base_listing_ids base_listing_ids_2 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.185 rows=1,000 loops=1)

59. 32.000 32.000 ↓ 209.5 419 1,000

CTE Scan on union_all_listings (cost=0.00..0.04 rows=2 width=8) (actual time=0.000..0.032 rows=419 loops=1,000)

60. 12.928 12.928 ↑ 60.2 76 404

Index Scan using geoloc_parcel_aggregate_listing_id_idx on geoloc_parcel_aggregate geoloc_parcelle_1 (cost=0.57..18,264.84 rows=4,575 width=20) (actual time=0.008..0.032 rows=76 loops=404)

  • Index Cond: (listing_id = base_listing_ids_2.listing_id)
  • Filter: (enabled AND enabled AND (model_id = 2,025,990,530))
  • Rows Removed by Filter: 0
61. 61.254 61.254 ↑ 1.0 1 30,627

Index Scan using geo_parcelle2_pkey on geo_parcelle2 parcelle_ref_1 (cost=0.57..8.23 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=30,627)

  • Index Cond: (id = geoloc_parcelle_1.parcel_id)
  • Filter: enabled
62.          

CTE parcelle_fuzzy_somme_bloc

63. 5.482 325.182 ↓ 2,687.0 2,687 1

GroupAggregate (cost=16.57..16.60 rows=1 width=20) (actual time=316.730..325.182 rows=2,687 loops=1)

  • Group Key: base_geoloc_parcelle_fuzzy.listing_id, parcelle_ref_2.block_id
64. 14.615 319.700 ↓ 30,627.0 30,627 1

Sort (cost=16.57..16.58 rows=1 width=20) (actual time=316.717..319.700 rows=30,627 loops=1)

  • Sort Key: base_geoloc_parcelle_fuzzy.listing_id, parcelle_ref_2.block_id
  • Sort Method: quicksort Memory: 3,161kB
65. 0.000 305.085 ↓ 30,627.0 30,627 1

Nested Loop (cost=0.99..16.56 rows=1 width=20) (actual time=0.402..305.085 rows=30,627 loops=1)

66. 14.491 244.858 ↓ 30,627.0 30,627 1

Nested Loop (cost=0.57..8.61 rows=1 width=20) (actual time=0.389..244.858 rows=30,627 loops=1)

67. 169.113 169.113 ↓ 30,627.0 30,627 1

CTE Scan on base_geoloc_parcelle_fuzzy (cost=0.00..0.02 rows=1 width=20) (actual time=0.379..169.113 rows=30,627 loops=1)

68. 61.254 61.254 ↑ 1.0 1 30,627

Index Scan using geo_parcelle2_pkey on geo_parcelle2 parcelle_ref_2 (cost=0.57..8.59 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=30,627)

  • Index Cond: (id = base_geoloc_parcelle_fuzzy.parcel_id)
  • Filter: enabled
69. 61.254 61.254 ↑ 1.0 1 30,627

Index Scan using geo_block2_pkey on geo_block2 block (cost=0.43..7.96 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=30,627)

  • Index Cond: (id = parcelle_ref_2.block_id)
  • Filter: enabled
70.          

CTE parcelle_fuzzy_somme_iris

71. 4.523 151.899 ↓ 802.0 802 1

GroupAggregate (cost=16.42..16.45 rows=1 width=20) (actual time=145.377..151.899 rows=802 loops=1)

  • Group Key: base_geoloc_parcelle_fuzzy_1.listing_id, parcelle_ref_3.iris_id
72. 12.901 147.376 ↓ 30,627.0 30,627 1

Sort (cost=16.42..16.43 rows=1 width=20) (actual time=145.354..147.376 rows=30,627 loops=1)

  • Sort Key: base_geoloc_parcelle_fuzzy_1.listing_id, parcelle_ref_3.iris_id
  • Sort Method: quicksort Memory: 3,161kB
73. 19.999 134.475 ↓ 30,627.0 30,627 1

Nested Loop (cost=0.86..16.41 rows=1 width=20) (actual time=0.036..134.475 rows=30,627 loops=1)

74. 18.162 83.849 ↓ 30,627.0 30,627 1

Nested Loop (cost=0.57..8.61 rows=1 width=20) (actual time=0.025..83.849 rows=30,627 loops=1)

75. 4.433 4.433 ↓ 30,627.0 30,627 1

CTE Scan on base_geoloc_parcelle_fuzzy base_geoloc_parcelle_fuzzy_1 (cost=0.00..0.02 rows=1 width=20) (actual time=0.001..4.433 rows=30,627 loops=1)

76. 61.254 61.254 ↑ 1.0 1 30,627

Index Scan using geo_parcelle2_pkey on geo_parcelle2 parcelle_ref_3 (cost=0.57..8.59 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=30,627)

  • Index Cond: (id = base_geoloc_parcelle_fuzzy_1.parcel_id)
  • Filter: enabled
77. 30.627 30.627 ↑ 1.0 1 30,627

Index Scan using geo_place2_pkey on geo_place2 gp_2 (cost=0.29..7.81 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=30,627)

  • Index Cond: (id = parcelle_ref_3.iris_id)
  • Filter: (enabled AND (type = 65))
78.          

CTE listing_fuzzy

79. 3.628 2,589.546 ↓ 11,350.0 11,350 1

WindowAgg (cost=0.10..0.12 rows=1 width=44) (actual time=2,585.164..2,589.546 rows=11,350 loops=1)

80. 7.744 2,585.918 ↓ 11,350.0 11,350 1

Sort (cost=0.10..0.10 rows=1 width=36) (actual time=2,585.155..2,585.918 rows=11,350 loops=1)

  • Sort Key: block_1.listing_id, block_1.presence_block, iris.presence_iris, block_1.block_id
  • Sort Method: quicksort Memory: 1,271kB
81. 849.507 2,578.174 ↓ 11,350.0 11,350 1

Nested Loop (cost=0.00..0.09 rows=1 width=36) (actual time=462.174..2,578.174 rows=11,350 loops=1)

  • Join Filter: (block_1.listing_id = base_listing_ids_3.listing_id)
  • Rows Removed by Join Filter: 11,338,650
82. 155.540 809.317 ↓ 11,350.0 11,350 1

Nested Loop (cost=0.00..0.05 rows=1 width=40) (actual time=462.117..809.317 rows=11,350 loops=1)

  • Join Filter: (block_1.listing_id = iris.listing_id)
  • Rows Removed by Join Filter: 2,143,624
83. 325.963 325.963 ↓ 2,687.0 2,687 1

CTE Scan on parcelle_fuzzy_somme_bloc block_1 (cost=0.00..0.02 rows=1 width=20) (actual time=316.733..325.963 rows=2,687 loops=1)

84. 327.814 327.814 ↓ 802.0 802 2,687

CTE Scan on parcelle_fuzzy_somme_iris iris (cost=0.00..0.02 rows=1 width=20) (actual time=0.054..0.122 rows=802 loops=2,687)

85. 919.350 919.350 ↓ 1,000.0 1,000 11,350

CTE Scan on base_listing_ids base_listing_ids_3 (cost=0.00..0.02 rows=1 width=12) (actual time=0.000..0.081 rows=1,000 loops=11,350)

86.          

CTE all_listings

87. 0.873 2,720.378 ↓ 284.7 854 1

HashAggregate (cost=0.16..0.19 rows=3 width=44) (actual time=2,720.002..2,720.378 rows=854 loops=1)

  • Group Key: (120), "*SELECT* 1".listing_id, "*SELECT* 1".block_id, (("*SELECT* 1".presence_block)::double precision), "*SELECT* 1".iris_id, (("*SELECT* 1".presence_iris)::double precision), "*SELECT* 1".city_id, (2080777928)
88. 0.070 2,719.505 ↓ 284.7 854 1

Append (cost=0.00..0.10 rows=3 width=44) (actual time=125.009..2,719.505 rows=854 loops=1)

89. 0.074 125.401 ↓ 298.0 596 1

Subquery Scan on *SELECT* 1 (cost=0.00..0.07 rows=2 width=44) (actual time=125.008..125.401 rows=596 loops=1)

90. 125.327 125.327 ↓ 298.0 596 1

CTE Scan on union_all_listings union_all_listings_1 (cost=0.00..0.04 rows=2 width=36) (actual time=125.006..125.327 rows=596 loops=1)

91. 2,594.034 2,594.034 ↓ 258.0 258 1

CTE Scan on listing_fuzzy (cost=0.00..0.02 rows=1 width=44) (actual time=2,585.168..2,594.034 rows=258 loops=1)

  • Filter: (rank = 1)
  • Rows Removed by Filter: 11,092
92. 0.113 2,722.575 ↓ 854.0 854 1

Nested Loop (cost=0.29..25.00 rows=1 width=56) (actual time=2,720.038..2,722.575 rows=854 loops=1)

93. 2,720.754 2,720.754 ↓ 284.7 854 1

CTE Scan on all_listings (cost=0.00..0.06 rows=3 width=44) (actual time=2,720.003..2,720.754 rows=854 loops=1)

94. 1.708 1.708 ↑ 1.0 1 854

Index Scan using geo_place2_pkey on geo_place2 places (cost=0.29..8.31 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=854)

  • Index Cond: (id = all_listings.city_id)
  • Filter: (active AND enabled AND (type = 40))
95. 3.416 3.416 ↑ 1.0 1 854

Index Scan using aggregate_rental_id_idx on aggregate_rental listings (cost=0.43..8.45 rows=1 width=57) (actual time=0.004..0.004 rows=1 loops=854)

  • Index Cond: (id = all_listings.listing_id)
96.          

SubPlan (for -------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop)

97. 0.000 6.832 ↑ 1.0 1 854

Subquery Scan on t (cost=108.08..109.70 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=854)

  • Filter: (t.rank = 1)
  • Rows Removed by Filter: 0
98. 0.854 6.832 ↑ 43.0 1 854

WindowAgg (cost=108.08..109.16 rows=43 width=40) (actual time=0.007..0.008 rows=1 loops=854)

99. 1.708 5.978 ↑ 43.0 1 854

Sort (cost=108.08..108.19 rows=43 width=28) (actual time=0.007..0.007 rows=1 loops=854)

  • Sort Key: price.date, price.id DESC
  • Sort Method: quicksort Memory: 25kB
100. 4.270 4.270 ↑ 43.0 1 854

Index Scan using price_aggregate_listing_id_idx on price_aggregate price (cost=0.56..106.92 rows=43 width=28) (actual time=0.005..0.005 rows=1 loops=854)

  • Index Cond: (listing_id = listings.id)
  • Filter: ((price IS NOT NULL) AND enabled AND (price > 0))
Planning time : 13.057 ms
Execution time : 2,737.405 ms