explain.depesz.com

PostgreSQL's explain analyze made readable

Result: an9U

Settings
# exclusive inclusive rows x rows loops node
1. 16.156 41.127 ↑ 4.0 100 1

Hash Right Join (cost=80.84..206.96 rows=399 width=1,645) (actual time=40.288..41.127 rows=100 loops=1)

  • Hash Cond: (core__tunnel_downtime__tunnel_incident.tunnel_incident = current_incident.id)
2. 15.093 15.093 ↑ 1.0 1,900 1

Seq Scan on tunnel_downtime core__tunnel_downtime__tunnel_incident (cost=0.00..115.00 rows=1,900 width=370) (actual time=0.016..15.093 rows=1,900 loops=1)

3. 0.986 9.878 ↑ 1.0 100 1

Hash (cost=79.59..79.59 rows=100 width=1,275) (actual time=9.878..9.878 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 100kB
4. 1.818 8.892 ↑ 1.0 100 1

Hash Left Join (cost=7.79..79.59 rows=100 width=1,275) (actual time=4.264..8.892 rows=100 loops=1)

  • Hash Cond: (me.current_incident = current_incident.id)
5. 1.737 2.890 ↑ 1.0 100 1

Limit (cost=0.00..69.54 rows=100 width=1,180) (actual time=0.038..2.890 rows=100 loops=1)

6. 1.153 1.153 ↑ 5.9 100 1

Seq Scan on tunnel me (cost=0.00..410.98 rows=591 width=1,180) (actual time=0.013..1.153 rows=100 loops=1)

  • Filter: ((up_since <= '2019-05-14 10:50:26+02'::timestamp with time zone) AND (current_state = 'up'::text))
  • Rows Removed by Filter: 563
7. 2.126 4.184 ↑ 1.0 213 1

Hash (cost=5.13..5.13 rows=213 width=95) (actual time=4.184..4.184 rows=213 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
8. 2.058 2.058 ↑ 1.0 213 1

Seq Scan on tunnel_incident current_incident (cost=0.00..5.13 rows=213 width=95) (actual time=0.014..2.058 rows=213 loops=1)

Planning time : 0.682 ms
Execution time : 42.007 ms