explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jtWt

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.390 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.69..342.02 rows=4 width=1,521) (actual time=1.386..1.390 rows=1 loops=1)

2. 0.002 1.387 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.55..341.07 rows=4 width=1,494) (actual time=1.383..1.387 rows=1 loops=1)

3. 0.004 1.380 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.40..339.82 rows=4 width=1,466) (actual time=1.377..1.380 rows=1 loops=1)

4. 0.002 1.371 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.26..338.09 rows=4 width=1,406) (actual time=1.369..1.371 rows=1 loops=1)

5. 0.004 1.368 ↑ 4.0 1 1

Nested Loop Left Join (cost=330.11..336.16 rows=4 width=1,384) (actual time=1.366..1.368 rows=1 loops=1)

6. 0.032 1.357 ↑ 4.0 1 1

Hash Semi Join (cost=329.97..332.98 rows=4 width=940) (actual time=1.355..1.357 rows=1 loops=1)

  • Hash Cond: (issue.id = "ANY_subquery".id)
7. 0.075 0.075 ↑ 1.0 77 1

Seq Scan on issue (cost=0.00..2.77 rows=77 width=940) (actual time=0.025..0.075 rows=77 loops=1)

8. 0.002 1.250 ↑ 4.0 1 1

Hash (cost=329.92..329.92 rows=4 width=8) (actual time=1.250..1.250 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.002 1.248 ↑ 4.0 1 1

Subquery Scan on ANY_subquery (cost=329.87..329.92 rows=4 width=8) (actual time=1.247..1.248 rows=1 loops=1)

10. 0.002 1.246 ↑ 4.0 1 1

Limit (cost=329.87..329.88 rows=4 width=16) (actual time=1.245..1.246 rows=1 loops=1)

11. 0.013 1.244 ↑ 4.0 1 1

Sort (cost=329.87..329.88 rows=4 width=16) (actual time=1.244..1.244 rows=1 loops=1)

  • Sort Key: issue_1.created_ts DESC
  • Sort Method: quicksort Memory: 25kB
12. 0.127 1.231 ↑ 4.0 1 1

Seq Scan on issue issue_1 (cost=0.00..329.83 rows=4 width=16) (actual time=1.230..1.231 rows=1 loops=1)

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

SubPlan (forSeq Scan)

14. 0.128 1.104 ↓ 0.0 0 8

Hash Join (cost=2.09..4.25 rows=1 width=0) (actual time=0.138..0.138 rows=0 loops=8)

  • Hash Cond: (inte.id = isin.interaction_id)
15. 0.392 0.392 ↑ 1.7 22 8

Seq Scan on interaction inte (cost=0.00..2.00 rows=38 width=8) (actual time=0.007..0.049 rows=22 loops=8)

  • Filter: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
  • Rows Removed by Filter: 37
16. 0.080 0.584 ↓ 2.0 2 8

Hash (cost=2.08..2.08 rows=1 width=8) (actual time=0.073..0.073 rows=2 loops=8)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.504 0.504 ↓ 2.0 2 8

Seq Scan on issue_interaction isin (cost=0.00..2.08 rows=1 width=8) (actual time=0.057..0.063 rows=2 loops=8)

  • Filter: (issue_id = issue_1.id)
  • Rows Removed by Filter: 84
18. 0.007 0.007 ↓ 0.0 0 1

Index Scan using issue_external_reference_issue_id_type_external_id_idx on issue_external_reference iser (cost=0.14..0.78 rows=1 width=452) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (issue_id = issue.id)
19. 0.001 0.001 ↓ 0.0 0 1

Index Scan using person_pkey on person pers_next_inte (cost=0.14..0.47 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (id = issue.next_interaction_person_id)
20. 0.005 0.005 ↑ 1.0 1 1

Index Scan using customer_pkey on customer cust (cost=0.14..0.42 rows=1 width=60) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = issue.customer_id)
21. 0.005 0.005 ↑ 1.0 1 1

Index Scan using person_pkey on person pers_owner (cost=0.14..0.30 rows=1 width=36) (actual time=0.004..0.005 rows=1 loops=1)

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

Index Scan using legal_entity_pkey on legal_entity leen (cost=0.14..0.23 rows=1 width=35) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (id = cust.legal_entity_id)