explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sTtX

Settings
# exclusive inclusive rows x rows loops node
1. 20.799 53.529 ↑ 4.0 100 1

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

  • Hash Cond: (core__tunnel_downtime__tunnel_incident.tunnel_incident = current_incident.id)
2. 19.624 19.624 ↑ 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.022..19.624 rows=1,900 loops=1)

3. 1.218 13.106 ↑ 1.0 100 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 100kB
4. 2.295 11.888 ↑ 1.0 100 1

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

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

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

6. 1.541 1.541 ↑ 5.9 100 1

Seq Scan on tunnel me (cost=0.00..410.98 rows=591 width=1,180) (actual time=0.029..1.541 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. 3.115 6.019 ↑ 1.0 213 1

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

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

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

Planning time : 1.610 ms
Execution time : 55.098 ms