explain.depesz.com

PostgreSQL's explain analyze made readable

Result: neq5

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 3,463.728 ↓ 1.5 21 1

Sort (cost=58,099.36..58,099.37 rows=14 width=33) (actual time=3,463.727..3,463.728 rows=21 loops=1)

  • Sort Key: v_s.disporder, s.sport_id
  • Sort Method: quicksort Memory: 26kB
2. 0.016 3,463.717 ↓ 1.5 21 1

HashAggregate (cost=58,099.27..58,099.31 rows=14 width=33) (actual time=3,463.714..3,463.717 rows=21 loops=1)

3. 0.005 3,463.701 ↓ 1.5 21 1

Append (cost=21,040.43..58,099.23 rows=14 width=33) (actual time=1,673.094..3,463.701 rows=21 loops=1)

4. 0.012 1,673.229 ↑ 2.0 6 1

Merge Join (cost=21,040.43..21,049.74 rows=12 width=34) (actual time=1,673.093..1,673.229 rows=6 loops=1)

  • Merge Cond: (c.ev_class_id = s.ob_id)
5. 0.017 1,673.068 ↑ 2.9 39 1

Nested Loop (cost=21,036.64..21,046.00 rows=115 width=13) (actual time=1,672.916..1,673.068 rows=39 loops=1)

6. 0.107 1,672.973 ↑ 2.9 39 1

Index Scan using cevclass_pk on tevclass c (cost=21,036.64..21,039.03 rows=115 width=15) (actual time=1,672.894..1,672.973 rows=39 loops=1)

  • Filter: (hashed SubPlan 2)
7.          

SubPlan (forIndex Scan)

8. 104.427 1,672.866 ↓ 1.4 39 1

HashAggregate (cost=21,036.55..21,036.63 rows=27 width=4) (actual time=1,672.861..1,672.866 rows=39 loops=1)

9. 77.215 1,568.439 ↓ 28.4 792,735 1

Nested Loop (cost=449.96..21,022.61 rows=27,876 width=4) (actual time=21.338..1,568.439 rows=792,735 loops=1)

10. 56.545 529.864 ↓ 16.0 192,272 1

Hash Join (cost=449.96..13,673.67 rows=12,037 width=8) (actual time=21.298..529.864 rows=192,272 loops=1)

  • Hash Cond: (e.ev_type_id = t.ev_type_id)
11. 72.057 460.152 ↓ 7.3 193,251 1

Hash Join (cost=187.39..13,315.39 rows=26,494 width=12) (actual time=8.107..460.152 rows=193,251 loops=1)

  • Hash Cond: (m.ev_id = e.ev_id)
12. 380.003 380.003 ↓ 5.4 240,191 1

Seq Scan on tevmkt m (cost=0.00..12,970.59 rows=44,529 width=8) (actual time=0.006..380.003 rows=240,191 loops=1)

  • Filter: ((status = 'A'::bpchar) AND (displayed = 'Y'::bpchar))
13. 1.944 8.092 ↓ 1.1 12,536 1

Hash (cost=149.19..149.19 rows=10,916 width=12) (actual time=8.092..8.092 rows=12,536 loops=1)

14. 6.148 6.148 ↓ 1.1 12,536 1

Seq Scan on tev e (cost=0.00..149.19 rows=10,916 width=12) (actual time=0.006..6.148 rows=12,536 loops=1)

  • Filter: ((status = 'A'::bpchar) AND (displayed = 'Y'::bpchar))
15. 3.741 13.167 ↓ 1.4 19,772 1

Hash (cost=214.50..214.50 rows=13,732 width=4) (actual time=13.167..13.167 rows=19,772 loops=1)

16. 9.426 9.426 ↓ 1.4 19,772 1

Seq Scan on tevtype t (cost=0.00..214.50 rows=13,732 width=4) (actual time=0.008..9.426 rows=19,772 loops=1)

  • Filter: ((status = 'A'::bpchar) AND (displayed = 'Y'::bpchar))
17. 961.360 961.360 ↑ 3.8 4 192,272

Index Scan using ievoc_ix1 on tevoc o (cost=0.00..0.56 rows=15 width=4) (actual time=0.002..0.005 rows=4 loops=192,272)

  • Index Cond: (o.ev_mkt_id = m.ev_mkt_id)
  • Filter: ((o.status = 'A'::bpchar) AND (o.displayed = 'Y'::bpchar))
18. 0.078 0.078 ↑ 1.0 1 39

Index Scan using ievcategory_ix1 on tevcategory y (cost=0.00..0.06 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=39)

  • Index Cond: (y.category = c.category)
19. 0.031 0.149 ↓ 2.4 56 1

Sort (cost=3.79..3.80 rows=23 width=25) (actual time=0.146..0.149 rows=56 loops=1)

  • Sort Key: s.ob_id
  • Sort Method: quicksort Memory: 29kB
20. 0.032 0.118 ↓ 2.5 58 1

Merge Join (cost=0.00..3.68 rows=23 width=25) (actual time=0.054..0.118 rows=58 loops=1)

  • Merge Cond: (s.sport_id = v_s.id)
21. 0.034 0.034 ↑ 1.0 58 1

Index Scan using csport_pk on tsport s (cost=0.00..0.71 rows=58 width=21) (actual time=0.021..0.034 rows=58 loops=1)

  • Filter: (ob_level = 'c'::bpchar)
22. 0.052 0.052 ↑ 1.2 81 1

Index Scan using iview_x2 on tview v_s (cost=0.00..5.69 rows=98 width=8) (actual time=0.024..0.052 rows=81 loops=1)

  • Index Cond: ((v_s.view = 'gb'::bpchar) AND (v_s.sort = 'SPT_PRE'::bpchar))
23. 0.003 1,790.467 ↓ 7.5 15 1

Nested Loop (cost=37,047.68..37,049.46 rows=2 width=30) (actual time=1,790.353..1,790.467 rows=15 loops=1)

24. 0.021 1,790.344 ↓ 2.5 15 1

Hash Join (cost=37,047.68..37,048.10 rows=6 width=26) (actual time=1,790.329..1,790.344 rows=15 loops=1)

  • Hash Cond: (s.ob_id = y.ev_category_id)
25. 0.012 0.012 ↑ 1.0 23 1

Seq Scan on tsport s (cost=0.00..0.38 rows=23 width=21) (actual time=0.002..0.012 rows=23 loops=1)

  • Filter: (ob_level = 'y'::bpchar)
26. 0.008 1,790.311 ↑ 1.2 16 1

Hash (cost=37,047.61..37,047.61 rows=20 width=13) (actual time=1,790.311..1,790.311 rows=16 loops=1)

27. 0.068 1,790.303 ↑ 1.2 16 1

Index Scan using cevcategory_pk on tevcategory y (cost=37,047.08..37,047.61 rows=20 width=13) (actual time=1,790.292..1,790.303 rows=16 loops=1)

  • Filter: (hashed SubPlan 1)
28.          

SubPlan (forIndex Scan)

29. 61.656 1,790.235 ↑ 1.8 16 1

Unique (cost=452.68..37,047.07 rows=29 width=11) (actual time=33.192..1,790.235 rows=16 loops=1)

30. 201.710 1,728.579 ↓ 37.6 792,735 1

Nested Loop (cost=452.68..37,036.52 rows=21,089 width=11) (actual time=33.191..1,728.579 rows=792,735 loops=1)

31. 24.554 757.781 ↓ 21.1 192,272 1

Nested Loop (cost=452.68..31,477.01 rows=9,106 width=15) (actual time=33.172..757.781 rows=192,272 loops=1)

32. 188.530 340.363 ↓ 3.3 12,277 1

Nested Loop (cost=452.68..6,083.23 rows=3,752 width=15) (actual time=33.141..340.363 rows=12,277 loops=1)

  • Join Filter: (t.ev_class_id = c.ev_class_id)
33. 0.480 0.480 ↓ 1.2 201 1

Index Scan using ievclass_ix3 on tevclass c (cost=0.00..21.93 rows=174 width=15) (actual time=0.010..0.480 rows=201 loops=1)

  • Filter: ((status = 'A'::bpchar) AND (displayed = 'Y'::bpchar))
34. 130.524 151.353 ↓ 2.5 12,277 201

Materialize (cost=452.68..467.55 rows=4,959 width=8) (actual time=0.053..0.753 rows=12,277 loops=201)

35. 3.455 20.829 ↓ 2.5 12,277 1

Hash Join (cost=262.56..451.19 rows=4,959 width=8) (actual time=10.659..20.829 rows=12,277 loops=1)

  • Hash Cond: (e.ev_type_id = t.ev_type_id)
36. 6.736 6.736 ↓ 1.1 12,536 1

Seq Scan on tev e (cost=0.00..149.19 rows=10,916 width=8) (actual time=0.008..6.736 rows=12,536 loops=1)

  • Filter: ((status = 'A'::bpchar) AND (displayed = 'Y'::bpchar))
37. 3.217 10.638 ↓ 1.4 19,772 1

Hash (cost=214.50..214.50 rows=13,732 width=8) (actual time=10.638..10.638 rows=19,772 loops=1)

38. 7.421 7.421 ↓ 1.4 19,772 1

Seq Scan on tevtype t (cost=0.00..214.50 rows=13,732 width=8) (actual time=0.007..7.421 rows=19,772 loops=1)

  • Filter: ((status = 'A'::bpchar) AND (displayed = 'Y'::bpchar))
39. 392.864 392.864 ↓ 1.6 16 12,277

Index Scan using ievmkt_ix3 on tevmkt m (cost=0.00..6.73 rows=10 width=8) (actual time=0.007..0.032 rows=16 loops=12,277)

  • Index Cond: (m.ev_id = e.ev_id)
  • Filter: ((m.status = 'A'::bpchar) AND (m.displayed = 'Y'::bpchar))
40. 769.088 769.088 ↑ 3.8 4 192,272

Index Scan using ievoc_ix1 on tevoc o (cost=0.00..0.56 rows=15 width=4) (actual time=0.002..0.004 rows=4 loops=192,272)

  • Index Cond: (o.ev_mkt_id = m.ev_mkt_id)
  • Filter: ((o.status = 'A'::bpchar) AND (o.displayed = 'Y'::bpchar))
41. 0.120 0.120 ↑ 1.0 1 15

Index Scan using iview_x2 on tview v_s (cost=0.00..0.22 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=15)

  • Index Cond: ((v_s.view = 'gb'::bpchar) AND (v_s.sort = 'SPT_PRE'::bpchar) AND (v_s.id = s.sport_id))