explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jqqa

Settings
# exclusive inclusive rows x rows loops node
1. 0.919 13.257 ↓ 1.6 1,065 1

Sort (cost=1,370.86..1,372.48 rows=648 width=95) (actual time=13.186..13.257 rows=1,065 loops=1)

  • Sort Key: dvrhealthstatusreport.actiontime
  • Sort Method: quicksort Memory: 328kB
2. 1.494 12.338 ↓ 1.6 1,065 1

Nested Loop (cost=927.89..1,340.60 rows=648 width=95) (actual time=7.330..12.338 rows=1,065 loops=1)

  • Join Filter: (dvr_healthcheck_latest.hc_id = dvrhealthstatusreport.id)
3. 0.801 8.714 ↓ 1.6 1,065 1

Hash Join (cost=927.61..1,037.37 rows=648 width=103) (actual time=7.308..8.714 rows=1,065 loops=1)

  • Hash Cond: (ff.dvr_id = dvr_healthcheck_latest.dvr_id)
4. 0.617 0.617 ↑ 1.0 3,002 1

Seq Scan on nddvr ff (cost=0.00..92.02 rows=3,002 width=29) (actual time=0.004..0.617 rows=3,002 loops=1)

  • Filter: (NOT isdeleted)
5. 0.454 7.296 ↓ 1.6 1,065 1

Hash (cost=919.51..919.51 rows=648 width=82) (actual time=7.296..7.296 rows=1,065 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 129kB
6. 0.603 6.842 ↓ 1.6 1,065 1

Hash Join (cost=418.84..919.51 rows=648 width=82) (actual time=5.254..6.842 rows=1,065 loops=1)

  • Hash Cond: (healthreportanddvrstatus.report_id = dvr_healthcheck_latest.hc_id)
7. 2.423 5.060 ↑ 1.1 2,452 1

Hash Join (cost=148.30..626.29 rows=2,591 width=66) (actual time=1.448..5.060 rows=2,452 loops=1)

  • Hash Cond: (healthreportanddvrstatus.dvrhealthstatus_id = dd.dvrhealthstatus_id)
8. 1.199 1.199 ↑ 1.0 12,005 1

Seq Scan on healthreportanddvrstatus (cost=0.00..377.05 rows=12,005 width=16) (actual time=0.003..1.199 rows=12,005 loops=1)

9. 0.861 1.438 ↑ 1.1 2,452 1

Hash (cost=115.91..115.91 rows=2,591 width=66) (actual time=1.438..1.438 rows=2,452 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 266kB
10. 0.577 0.577 ↑ 1.1 2,452 1

Seq Scan on diskhealthstatus dd (cost=0.00..115.91 rows=2,591 width=66) (actual time=0.003..0.577 rows=2,452 loops=1)

11. 0.571 1.179 ↑ 1.0 3,002 1

Hash (cost=233.02..233.02 rows=3,002 width=16) (actual time=1.179..1.179 rows=3,002 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 141kB
12. 0.608 0.608 ↑ 1.0 3,002 1

Seq Scan on dvr_healthcheck_latest (cost=0.00..233.02 rows=3,002 width=16) (actual time=0.006..0.608 rows=3,002 loops=1)

13. 2.130 2.130 ↑ 1.0 1 1,065

Index Scan using dvrhealthstatusreport_id_pk on dvrhealthstatusreport (cost=0.29..0.43 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=1,065)

  • Index Cond: (id = healthreportanddvrstatus.report_id)
Planning time : 2.601 ms
Execution time : 13.814 ms