explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RZUL

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

Nested Loop Left Join (cost=174.25..206.53 rows=14 width=6,766) (actual time=0.014..0.014 rows=0 loops=1)

2. 0.001 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=174.10..199.79 rows=2 width=6,322) (actual time=0.014..0.014 rows=0 loops=1)

3. 0.001 0.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=173.96..198.48 rows=2 width=5,714) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.000 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=173.82..197.16 rows=2 width=5,186) (actual time=0.012..0.012 rows=0 loops=1)

5. 0.001 0.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=173.68..190.42 rows=2 width=4,982) (actual time=0.012..0.013 rows=0 loops=1)

6. 0.000 0.012 ↓ 0.0 0 1

Hash Semi Join (cost=173.54..183.68 rows=2 width=4,538) (actual time=0.012..0.012 rows=0 loops=1)

  • Hash Cond: (issue.id = "ANY_subquery".id)
7. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on issue (cost=0.00..10.10 rows=10 width=4,538) (actual time=0.012..0.012 rows=0 loops=1)

8. 0.000 0.000 ↓ 0.0 0

Hash (cost=173.51..173.51 rows=2 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Subquery Scan on ANY_subquery (cost=173.49..173.51 rows=2 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Limit (cost=173.49..173.49 rows=2 width=16) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Sort (cost=173.49..173.49 rows=2 width=16) (never executed)

  • Sort Key: issue_1.created_ts DESC
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on issue issue_1 (cost=0.00..173.48 rows=2 width=16) (never executed)

  • Filter: ((created_ts > '2019-01-01 00:00:00+02'::timestamp with time zone) AND (SubPlan 1))
13.          

SubPlan (forSeq Scan)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..16.34 rows=1 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using issue_interaction_issue_id_interaction_id_idx on issue_interaction isin (cost=0.14..8.16 rows=1 width=8) (never executed)

  • Index Cond: (issue_id = issue_1.id)
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Index Scan using interaction_pkey on interaction inte (cost=0.14..8.16 rows=1 width=8) (never executed)

  • Index Cond: (id = isin.interaction_id)
  • Filter: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person pers_next_inte (cost=0.14..3.36 rows=1 width=444) (never executed)

  • Index Cond: (id = issue.next_interaction_person_id)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using customer_pkey on customer cust (cost=0.14..3.36 rows=1 width=204) (never executed)

  • Index Cond: (id = issue.customer_id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person pers_owner (cost=0.14..0.65 rows=1 width=536) (never executed)

  • Index Cond: (id = cust.owner_person_id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using legal_entity_pkey on legal_entity leen (cost=0.14..0.65 rows=1 width=616) (never executed)

  • Index Cond: (id = cust.legal_entity_id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using issue_external_reference_issue_id_type_external_id_idx on issue_external_reference iser (cost=0.14..3.36 rows=1 width=452) (never executed)

  • Index Cond: (issue_id = issue.id)