explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1JbR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.328 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.72..23.32 rows=5 width=1,521) (actual time=0.324..0.328 rows=1 loops=1)

2. 0.004 0.326 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.58..22.14 rows=5 width=1,494) (actual time=0.322..0.326 rows=1 loops=1)

3. 0.002 0.316 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.44..20.58 rows=5 width=1,466) (actual time=0.314..0.316 rows=1 loops=1)

4. 0.002 0.309 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.29..18.42 rows=5 width=1,406) (actual time=0.307..0.309 rows=1 loops=1)

5. 0.002 0.306 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.15..16.00 rows=5 width=1,384) (actual time=0.305..0.306 rows=1 loops=1)

6. 0.047 0.296 ↑ 5.0 1 1

Hash Semi Join (cost=9.01..12.03 rows=5 width=940) (actual time=0.295..0.296 rows=1 loops=1)

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

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

8. 0.003 0.188 ↑ 5.0 1 1

Hash (cost=8.94..8.94 rows=5 width=8) (actual time=0.188..0.188 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.001 0.185 ↑ 5.0 1 1

Subquery Scan on ANY_subquery (cost=8.88..8.94 rows=5 width=8) (actual time=0.185..0.185 rows=1 loops=1)

10. 0.000 0.184 ↑ 5.0 1 1

Limit (cost=8.88..8.89 rows=5 width=16) (actual time=0.184..0.184 rows=1 loops=1)

11. 0.013 0.184 ↑ 5.0 1 1

Sort (cost=8.88..8.89 rows=5 width=16) (actual time=0.184..0.184 rows=1 loops=1)

  • Sort Key: issue_1.created_ts DESC
  • Sort Method: quicksort Memory: 25kB
12. 0.019 0.171 ↑ 5.0 1 1

Hash Semi Join (cost=5.76..8.82 rows=5 width=16) (actual time=0.170..0.171 rows=1 loops=1)

  • Hash Cond: (issue_1.id = isin.issue_id)
13. 0.039 0.039 ↑ 1.0 8 1

Seq Scan on issue issue_1 (cost=0.00..2.96 rows=8 width=16) (actual time=0.018..0.039 rows=8 loops=1)

  • Filter: (created_ts > '2019-01-01 00:00:00+02'::timestamp with time zone)
  • Rows Removed by Filter: 69
14. 0.006 0.113 ↑ 2.1 23 1

Hash (cost=5.15..5.15 rows=49 width=8) (actual time=0.113..0.113 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.047 0.107 ↑ 2.1 23 1

Hash Join (cost=2.48..5.15 rows=49 width=8) (actual time=0.075..0.107 rows=23 loops=1)

  • Hash Cond: (isin.interaction_id = inte.id)
16. 0.013 0.013 ↑ 1.0 86 1

Seq Scan on issue_interaction isin (cost=0.00..1.86 rows=86 width=16) (actual time=0.011..0.013 rows=86 loops=1)

17. 0.010 0.047 ↑ 1.5 25 1

Hash (cost=2.00..2.00 rows=38 width=8) (actual time=0.047..0.047 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.037 0.037 ↑ 1.5 25 1

Seq Scan on interaction inte (cost=0.00..2.00 rows=38 width=8) (actual time=0.013..0.037 rows=25 loops=1)

  • Filter: ((created_by_person_id = 1) OR (behalf_of_person_id = 1))
  • Rows Removed by Filter: 42
19. 0.008 0.008 ↓ 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.008 rows=0 loops=1)

  • Index Cond: (issue_id = issue.id)
20. 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)
21. 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)
22. 0.006 0.006 ↑ 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.005..0.006 rows=1 loops=1)

  • Index Cond: (id = cust.owner_person_id)
23. 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)