explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PZKv

Settings
# exclusive inclusive rows x rows loops node
1. 11.473 14.856 ↑ 1.0 100 1

Gather (cost=1,247.80..7,216.92 rows=100 width=725) (actual time=5.855..14.856 rows=100 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.046 3.382 ↑ 1.0 100 1 / 2

Limit (cost=247.80..6,206.92 rows=100 width=725) (actual time=0.232..6.765 rows=100 loops=1)

3. 0.255 3.336 ↑ 35,072.0 100 1 / 2

Unique (cost=247.80..208,998,021.88 rows=3,507,197 width=725) (actual time=0.229..6.672 rows=100 loops=1)

4. 0.453 3.081 ↑ 3,976.4 882 1 / 2

Nested Loop (cost=247.80..206,367,624.13 rows=3,507,197 width=725) (actual time=0.225..6.162 rows=882 loops=1)

5. 0.420 1.746 ↑ 3,976.4 882 1 / 2

Merge Append (cost=218.80..103,727,505.42 rows=3,507,197 width=11) (actual time=0.195..3.492 rows=882 loops=1)

  • Sort Key: products_displayproductaccess_753.is_instock DESC, products_displayproductaccess_753.price DESC, products_displayproductaccess_753.product_id
6. 0.183 0.183 ↑ 3,365.7 59 1 / 2

Index Scan using products_displayproductacces_is_instock_price_product_id_idx744 on products_displayproductaccess_753 (cost=42.50..13,193,970.42 rows=198,575 width=11) (actual time=0.030..0.367 rows=59 loops=1)

  • Filter: ((location_intspace = ANY ('{753,754,755,756,757}'::integer[])) AND (location_id = ANY ('{1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,89,1055,1056,604,47,50,51,52,606,55,58,59,60,61,62,64,65,66,68,69,70,97,72,73,75,76,78,79,81,594,83,84,597,598,599,600,601,602,603,92,605,94,607,608,609,610,611,612,101,102,104,617,618,108,109,624,113,114,627,116,118,631,632,633,634,635,636,637,639,130,131,133,134,620,621,149,150,151,155,626,1523,630,120,121,124,53,909,910,593,1519,99,932,934,935,937,947,948,949,950,951,952,953,954,955,973,974,975,999,1517,1518,613,1520,1521,1522,595,1524,1525,1526,1528,1530,1531,1532,1533,1534,85}'::integer[])))
  • Rows Removed by Filter: 124
7. 0.294 0.294 ↑ 3,366.3 185 1 / 2

Index Scan using products_displayproductacces_is_instock_price_product_id_idx745 on products_displayproductaccess_754 (cost=42.50..17,516,963.37 rows=622,771 width=11) (actual time=0.024..0.589 rows=185 loops=1)

  • Filter: ((location_intspace = ANY ('{753,754,755,756,757}'::integer[])) AND (location_id = ANY ('{1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,89,1055,1056,604,47,50,51,52,606,55,58,59,60,61,62,64,65,66,68,69,70,97,72,73,75,76,78,79,81,594,83,84,597,598,599,600,601,602,603,92,605,94,607,608,609,610,611,612,101,102,104,617,618,108,109,624,113,114,627,116,118,631,632,633,634,635,636,637,639,130,131,133,134,620,621,149,150,151,155,626,1523,630,120,121,124,53,909,910,593,1519,99,932,934,935,937,947,948,949,950,951,952,953,954,955,973,974,975,999,1517,1518,613,1520,1521,1522,595,1524,1525,1526,1528,1530,1531,1532,1533,1534,85}'::integer[])))
  • Rows Removed by Filter: 77
8. 0.411 0.411 ↑ 4,186.1 401 1 / 2

Index Scan using products_displayproductacces_is_instock_price_product_id_idx746 on products_displayproductaccess_755 (cost=42.75..34,122,639.48 rows=1,678,642 width=11) (actual time=0.078..0.823 rows=401 loops=1)

  • Filter: ((location_intspace = ANY ('{753,754,755,756,757}'::integer[])) AND (location_id = ANY ('{1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,89,1055,1056,604,47,50,51,52,606,55,58,59,60,61,62,64,65,66,68,69,70,97,72,73,75,76,78,79,81,594,83,84,597,598,599,600,601,602,603,92,605,94,607,608,609,610,611,612,101,102,104,617,618,108,109,624,113,114,627,116,118,631,632,633,634,635,636,637,639,130,131,133,134,620,621,149,150,151,155,626,1523,630,120,121,124,53,909,910,593,1519,99,932,934,935,937,947,948,949,950,951,952,953,954,955,973,974,975,999,1517,1518,613,1520,1521,1522,595,1524,1525,1526,1528,1530,1531,1532,1533,1534,85}'::integer[])))
  • Rows Removed by Filter: 32
9. 0.276 0.276 ↑ 4,563.1 188 1 / 2

Index Scan using products_displayproductacces_is_instock_price_product_id_idx747 on products_displayproductaccess_756 (cost=42.75..22,975,766.40 rows=857,859 width=11) (actual time=0.027..0.551 rows=188 loops=1)

  • Filter: ((location_intspace = ANY ('{753,754,755,756,757}'::integer[])) AND (location_id = ANY ('{1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,89,1055,1056,604,47,50,51,52,606,55,58,59,60,61,62,64,65,66,68,69,70,97,72,73,75,76,78,79,81,594,83,84,597,598,599,600,601,602,603,92,605,94,607,608,609,610,611,612,101,102,104,617,618,108,109,624,113,114,627,116,118,631,632,633,634,635,636,637,639,130,131,133,134,620,621,149,150,151,155,626,1523,630,120,121,124,53,909,910,593,1519,99,932,934,935,937,947,948,949,950,951,952,953,954,955,973,974,975,999,1517,1518,613,1520,1521,1522,595,1524,1525,1526,1528,1530,1531,1532,1533,1534,85}'::integer[])))
  • Rows Removed by Filter: 106
10. 0.161 0.161 ↑ 2,817.9 53 1 / 2

Index Scan using products_displayproductacces_is_instock_price_product_id_idx748 on products_displayproductaccess_757 (cost=42.50..11,828,894.34 rows=149,350 width=11) (actual time=0.027..0.321 rows=53 loops=1)

  • Filter: ((location_intspace = ANY ('{753,754,755,756,757}'::integer[])) AND (location_id = ANY ('{1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,89,1055,1056,604,47,50,51,52,606,55,58,59,60,61,62,64,65,66,68,69,70,97,72,73,75,76,78,79,81,594,83,84,597,598,599,600,601,602,603,92,605,94,607,608,609,610,611,612,101,102,104,617,618,108,109,624,113,114,627,116,118,631,632,633,634,635,636,637,639,130,131,133,134,620,621,149,150,151,155,626,1523,630,120,121,124,53,909,910,593,1519,99,932,934,935,937,947,948,949,950,951,952,953,954,955,973,974,975,999,1517,1518,613,1520,1521,1522,595,1524,1525,1526,1528,1530,1531,1532,1533,1534,85}'::integer[])))
  • Rows Removed by Filter: 103
11. 0.882 0.882 ↑ 1.0 1 882 / 2

Index Scan using products_di_id_f3063a_idx on products_displayproduct (cost=29.00..29.27 rows=1 width=718) (actual time=0.002..0.002 rows=1 loops=882)

  • Index Cond: (id = products_displayproductaccess_753.product_id)