explain.depesz.com

PostgreSQL's explain analyze made readable

Result: usyna

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 7,826.523 ↑ 1.0 100 1

Limit (cost=42,775,595.42..42,775,620.42 rows=100 width=11) (actual time=7,826.414..7,826.523 rows=100 loops=1)

2. 22.134 7,826.443 ↑ 477.8 100 1

Sort (cost=42,775,595.42..42,787,540.67 rows=47,781 width=11) (actual time=7,826.412..7,826.443 rows=100 loops=1)

  • Sort Key: products_displayproductaccess_755.price DESC, products_displayproductaccess_755.is_instock DESC, products_displayproductaccess_755.product_id
  • Sort Method: top-N heapsort Memory: 32kB
3. 1,204.053 7,804.309 ↓ 1.1 51,151 1

Unique (cost=40,838,903.57..42,592,502.07 rows=47,781 width=11) (actual time=4,571.246..7,804.309 rows=51,151 loops=1)

4. 4,648.343 6,600.256 ↓ 1.0 3,508,394 1

Sort (cost=40,838,903.57..41,715,702.82 rows=3,507,197 width=11) (actual time=4,571.244..6,600.256 rows=3,508,394 loops=1)

  • Sort Key: products_displayproductaccess_755.product_id, products_displayproductaccess_755.price DESC, products_displayproductaccess_755.is_instock DESC
  • Sort Method: external merge Disk: 75512kB
5. 0.000 1,951.913 ↓ 1.0 3,508,394 1

Gather (cost=1,042.50..2,677,256.82 rows=3,507,197 width=11) (actual time=1.184..1,951.913 rows=3,508,394 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
6. 631.969 2,165.060 ↑ 1.3 877,098 4 / 4

Parallel Append (cost=42.50..2,325,537.12 rows=1,131,354 width=11) (actual time=0.127..2,165.060 rows=877,098 loops=4)

7. 852.476 852.476 ↑ 2.4 419,886 4 / 4

Parallel Index Scan using products_displayproductaccess_755_location_id_idx on products_displayproductaccess_755 (cost=42.75..1,091,008.79 rows=987,436 width=11) (actual time=0.047..852.476 rows=419,886 loops=4)

  • Index Cond: (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[]))
  • Filter: (location_intspace = ANY ('{753,754,755,756,757}'::integer[]))
8. 353.163 353.163 ↑ 1.2 429,208 2 / 4

Parallel Index Scan using products_displayproductaccess_756_location_id_idx on products_displayproductaccess_756 (cost=42.75..565,053.00 rows=504,623 width=11) (actual time=0.059..706.326 rows=429,208 loops=2)

  • Index Cond: (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[]))
  • Filter: (location_intspace = ANY ('{753,754,755,756,757}'::integer[]))
9. 217.004 217.004 ↓ 1.7 622,077 1 / 4

Parallel Index Scan using products_displayproductaccess_754_location_id_idx on products_displayproductaccess_754 (cost=42.50..412,529.66 rows=366,336 width=11) (actual time=0.127..868.017 rows=622,077 loops=1)

  • Index Cond: (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[]))
  • Filter: (location_intspace = ANY ('{753,754,755,756,757}'::integer[]))
10. 64.613 64.613 ↓ 1.7 199,057 1 / 4

Parallel Index Scan using products_displayproductaccess_753_location_id_idx on products_displayproductaccess_753 (cost=42.50..141,703.89 rows=116,809 width=11) (actual time=0.122..258.453 rows=199,057 loops=1)

  • Index Cond: (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[]))
  • Filter: (location_intspace = ANY ('{753,754,755,756,757}'::integer[]))
11. 45.834 45.834 ↑ 1.2 74,650 2 / 4

Parallel Index Scan using products_displayproductaccess_757_location_id_idx on products_displayproductaccess_757 (cost=42.50..109,585.01 rows=87,853 width=11) (actual time=0.113..91.669 rows=74,650 loops=2)

  • Index Cond: (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[]))
  • Filter: (location_intspace = ANY ('{753,754,755,756,757}'::integer[]))
Planning time : 1.379 ms
Execution time : 7,839.731 ms