explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7imM

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.428 ↓ 0.0 0 1

Nested Loop Left Join (cost=15.57..23.57 rows=4 width=865) (actual time=0.428..0.428 rows=0 loops=1)

2. 0.031 0.409 ↓ 0.0 0 1

Hash Right Join (cost=15.29..21.23 rows=1 width=495) (actual time=0.409..0.409 rows=0 loops=1)

  • Hash Cond: (current_incident.id = me.current_incident)
3. 0.000 0.000 ↓ 0.0 0

Seq Scan on tunnel_incident current_incident (cost=0.00..5.13 rows=213 width=95) (never executed)

4. 0.018 0.378 ↓ 0.0 0 1

Hash (cost=15.28..15.28 rows=1 width=400) (actual time=0.378..0.378 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.018 0.360 ↓ 0.0 0 1

Subquery Scan on me (cost=0.25..15.28 rows=1 width=400) (actual time=0.360..0.360 rows=0 loops=1)

  • Filter: ((me.current_incident IS NOT NULL) AND (me.up_since <= '2019-05-15 10:50:26+02'::timestamp with time zone) AND (me.current_state = 'up'::text))
6. 0.018 0.342 ↓ 0.0 0 1

Limit (cost=0.25..15.25 rows=2 width=400) (actual time=0.342..0.342 rows=0 loops=1)

7. 0.324 0.324 ↓ 0.0 0 1

Function Scan on tunnel me_1 (cost=0.25..15.25 rows=2 width=400) (actual time=0.324..0.324 rows=0 loops=1)

  • Filter: ((current_incident IS NOT NULL) AND (up_since <= '2019-05-15 10:50:26+02'::timestamp with time zone) AND (current_state = 'up'::text))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tunnel_incident on tunnel_downtime core__tunnel_downtime__tunnel_incident (cost=0.28..2.30 rows=4 width=370) (never executed)

  • Index Cond: (tunnel_incident = current_incident.id)