explain.depesz.com

PostgreSQL's explain analyze made readable

Result: De6a : asda

Settings
# exclusive inclusive rows x rows loops node
1. 23.420 89.560 ↓ 183.3 1,100 1

Bitmap Heap Scan on usr_dodatki d (cost=4.31..595.71 rows=6 width=32) (actual time=0.342..89.560 rows=1,100 loops=1)

  • Recheck Cond: ((tip > 3) AND ((variant & 1) = 1))
  • Heap Blocks: exact=19
2. 0.140 0.140 ↓ 183.3 1,100 1

Bitmap Index Scan on dodatki_types (cost=0.00..4.31 rows=6 width=0) (actual time=0.140..0.140 rows=1,100 loops=1)

3.          

SubPlan (for Bitmap Heap Scan)

4. 0.000 7.700 ↓ 0.0 0 1,100

Limit (cost=0.70..16.76 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1,100)

5. 1.508 7.700 ↓ 0.0 0 1,100

Nested Loop (cost=0.70..16.76 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1,100)

6. 5.500 5.500 ↓ 0.0 0 1,100

Index Scan using lastnost_conn on usr_lastnostielementa l (cost=0.42..8.45 rows=1 width=7) (actual time=0.005..0.005 rows=0 loops=1,100)

  • Index Cond: ((element = d.id) AND ((element_na)::integer = 289))
  • Filter: ((variant & 1) = 1)
  • Rows Removed by Filter: 0
7. 0.692 0.692 ↑ 1.0 1 346

Index Scan using usr_vrata_pkey on usr_vrata v (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=346)

  • Index Cond: (id = 289)
  • Filter: ((attr & 257) = 0)
8. 1.100 5.500 ↑ 1.0 1 1,100

Limit (cost=0.28..8.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1,100)

9. 4.400 4.400 ↑ 1.0 1 1,100

Index Scan using lastnost_price on usr_lastnostielementa l_1 (cost=0.28..8.31 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1,100)

  • Index Cond: (element = d.id)
  • Filter: ((variant & 1) = 1)
10. 4.400 7.700 ↑ 1.0 1 1,100

Aggregate (cost=8.30..8.31 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=1,100)

11. 3.300 3.300 ↓ 2.0 2 1,100

Index Scan using lastnost_tags on usr_lastnostielementa l_2 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=2 loops=1,100)

  • Index Cond: (element = d.id)
12. 1.100 3.300 ↑ 1.0 1 1,100

Aggregate (cost=8.17..8.18 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1,100)

13. 2.200 2.200 ↓ 0.0 0 1,100

Index Scan using lastnost_groups on usr_lastnostielementa l_3 (cost=0.15..8.17 rows=1 width=1) (actual time=0.002..0.002 rows=0 loops=1,100)

  • Index Cond: (element = d.id)
14. 2.200 9.900 ↑ 1.0 1 1,100

Aggregate (cost=8.33..8.34 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=1,100)

15. 1.100 7.700 ↑ 1.0 1 1,100

Unique (cost=8.30..8.31 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1,100)

16. 3.300 6.600 ↑ 1.0 1 1,100

Sort (cost=8.30..8.31 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1,100)

  • Sort Key: l_4.vrednost
  • Sort Method: quicksort Memory: 25kB
17. 3.300 3.300 ↑ 1.0 1 1,100

Index Scan using lastnost_position on usr_lastnostielementa l_4 (cost=0.28..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1,100)

  • Index Cond: (element = d.id)
18. 1.100 3.300 ↓ 0.0 0 1,100

Limit (cost=0.27..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1,100)

19. 2.200 2.200 ↓ 0.0 0 1,100

Index Scan using lastnost_length on usr_lastnostielementa l_5 (cost=0.27..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,100)

  • Index Cond: (element = d.id)
20. 0.000 2.200 ↓ 0.0 0 1,100

Limit (cost=0.27..8.29 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1,100)

21. 2.200 2.200 ↓ 0.0 0 1,100

Index Scan using element_height_limit on usr_pirnarcenevec p (cost=0.27..8.29 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1,100)

  • Index Cond: (element = d.id)
  • Filter: ((variant & 1) = 1)
  • Rows Removed by Filter: 0
22. 14.300 20.900 ↑ 1.0 1 1,100

Aggregate (cost=21.28..21.29 rows=1 width=32) (actual time=0.019..0.019 rows=1 loops=1,100)

23. 6.600 6.600 ↓ 1.2 7 1,100

Index Scan using dodatki_prevodi on spl_vsiprevodi tr (cost=0.29..21.26 rows=6 width=55) (actual time=0.003..0.006 rows=7 loops=1,100)

  • Index Cond: (element = d.id)
24. 0.000 5.500 ↓ 0.0 0 1,100

Limit (cost=0.42..8.44 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1,100)

25. 5.500 5.500 ↓ 0.0 0 1,100

Index Scan using usr_lastnostielementa_element_lastnost_element_na_idx on usr_lastnostielementa l_6 (cost=0.42..8.44 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1,100)

  • Index Cond: ((element = d.id) AND (lastnost = 10,100,115))