explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dyg

Settings
# exclusive inclusive rows x rows loops node
1. 0.551 8.510 ↓ 1.6 1,065 1

Sort (cost=1,369.24..1,370.86 rows=648 width=95) (actual time=8.475..8.510 rows=1,065 loops=1)

  • Sort Key: aa.actiontime
  • Sort Method: quicksort Memory: 328kB
2. 0.976 7.959 ↓ 1.6 1,065 1

Nested Loop (cost=927.89..1,338.98 rows=648 width=95) (actual time=5.130..7.959 rows=1,065 loops=1)

3. 0.486 5.918 ↓ 1.6 1,065 1

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

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

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

  • Filter: (NOT isdeleted)
5. 0.270 5.083 ↓ 1.6 1,065 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 133kB
6. 0.492 4.813 ↓ 1.6 1,065 1

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

  • Hash Cond: (bb.report_id = latest_report.hc_id)
7. 1.583 3.337 ↑ 1.1 2,452 1

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

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

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

9. 0.510 0.970 ↑ 1.1 2,452 1

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

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

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

11. 0.415 0.984 ↑ 1.0 3,002 1

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

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

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

13. 1.065 1.065 ↑ 1.0 1 1,065

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

  • Index Cond: (id = bb.report_id)
Planning time : 1.297 ms
Execution time : 9.127 ms