explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IPOl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.42..88,666.15 rows=2,001 width=63) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan Backward using problem_pkey on problem p (cost=0.42..11,900,926.50 rows=268,579 width=63) (actual rows= loops=)

  • Filter: (((r_eventid IS NULL) OR (r_clock > 1592866350)) AND (source = 0) AND (object = 0) AND (NOT (SubPlan 1)))
3.          

SubPlan (for Index Scan Backward)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=21.57..21.70 rows=9 width=12) (actual rows= loops=)

  • Filter: ((max(r.permission) < 2) OR (min(r.permission) IS NULL) OR (min(r.permission) = 0))
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.56..21.48 rows=9 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..16.15 rows=9 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..15.08 rows=2 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using functions_1 on functions f (cost=0.43..6.16 rows=2 width=8) (actual rows= loops=)

  • Index Cond: (p.objectid = triggerid)
9. 0.000 0.000 ↓ 0.0

Index Scan using items_pkey on items i (cost=0.43..4.45 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (itemid = f.itemid)
10. 0.000 0.000 ↓ 0.0

Index Only Scan using hosts_groups_1 on hosts_groups hgg (cost=0.41..0.50 rows=4 width=16) (actual rows= loops=)

  • Index Cond: (hostid = i.hostid)
11. 0.000 0.000 ↓ 0.0

Index Scan using rights_2 on rights r (cost=0.29..0.58 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = hgg.groupid)
  • Filter: (groupid = 128,545)