explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YcaX

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.115 ↓ 0.0 0 1

Limit (cost=12,942.84..13,942.84 rows=100 width=11) (actual time=0.115..0.115 rows=0 loops=1)

2. 0.001 0.114 ↓ 0.0 0 1

Unique (cost=12,942.84..13,942.84 rows=100 width=11) (actual time=0.113..0.114 rows=0 loops=1)

3. 0.004 0.113 ↓ 0.0 0 1

Sort (cost=12,942.84..13,442.84 rows=2,000 width=11) (actual time=0.112..0.113 rows=0 loops=1)

  • Sort Key: products_displayproductaccess_755.product_id
  • Sort Method: quicksort Memory: 25kB
4. 0.004 0.109 ↓ 0.0 0 1

Nested Loop (cost=43.75..1,977.06 rows=2,000 width=11) (actual time=0.108..0.109 rows=0 loops=1)

5. 0.003 0.005 ↑ 1.0 2 1

ProjectSet (cost=0.00..0.28 rows=2 width=32) (actual time=0.003..0.005 rows=2 loops=1)

6. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

7. 0.026 0.100 ↓ 0.0 0 2

Nested Loop (cost=43.75..978.38 rows=1,000 width=11) (actual time=0.050..0.050 rows=0 loops=2)

8. 0.012 0.014 ↑ 1.0 10 2

ProjectSet (cost=0.00..0.32 rows=10 width=32) (actual time=0.002..0.007 rows=10 loops=2)

9. 0.002 0.002 ↑ 1.0 1 2

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=2)

10. 0.020 0.060 ↓ 0.0 0 20

Limit (cost=43.75..95.80 rows=100 width=11) (actual time=0.003..0.003 rows=0 loops=20)

11. 0.040 0.040 ↓ 0.0 0 20

Index Only Scan using products_displayproductacces_location_id_location_intspac_idx10 on products_displayproductaccess_755 (cost=43.75..25,603.29 rows=49,109 width=11) (actual time=0.002..0.002 rows=0 loops=20)

  • Index Cond: ((location_id = ((unnest('{1,2,3,4,5,1511,940,931,660,661}'::text[])))::integer) AND (location_intspace = ((unnest('{758,759}'::text[])))::integer))
  • Heap Fetches: 0