explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A5cD

Settings
# exclusive inclusive rows x rows loops node
1. 0.129 8.186 ↑ 2.1 291 1

Sort (cost=1,589.48..1,591.02 rows=617 width=96) (actual time=8.176..8.186 rows=291 loops=1)

  • Sort Key: aa.actiontime
  • Sort Method: quicksort Memory: 100kB
2. 0.235 8.057 ↑ 2.1 291 1

Nested Loop (cost=1,164.25..1,560.89 rows=617 width=96) (actual time=7.029..8.057 rows=291 loops=1)

3. 0.206 7.531 ↑ 2.1 291 1

Hash Join (cost=1,163.97..1,273.47 rows=623 width=104) (actual time=7.008..7.531 rows=291 loops=1)

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

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

  • Filter: (NOT isdeleted)
5. 0.076 6.999 ↑ 2.1 291 1

Hash (cost=1,156.18..1,156.18 rows=623 width=83) (actual time=6.999..6.999 rows=291 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
6. 1.475 6.923 ↑ 2.1 291 1

Hash Join (cost=486.11..1,156.18 rows=623 width=83) (actual time=3.364..6.923 rows=291 loops=1)

  • Hash Cond: (bb.dvrhealthstatus_id = dd.dvrhealthstatus_id)
7. 2.182 4.110 ↑ 1.0 3,001 1

Hash Join (cost=270.55..915.63 rows=3,002 width=32) (actual time=2.022..4.110 rows=3,001 loops=1)

  • Hash Cond: (bb.report_id = latest_report.hc_id)
8. 1.136 1.136 ↓ 1.0 17,518 1

Seq Scan on healthreportanddvrstatus bb (cost=0.00..508.50 rows=17,050 width=16) (actual time=0.002..1.136 rows=17,518 loops=1)

9. 0.324 0.792 ↑ 1.0 3,002 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 141kB
10. 0.468 0.468 ↑ 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.002..0.468 rows=3,002 loops=1)

11. 0.788 1.338 ↓ 1.2 4,174 1

Hash (cost=171.36..171.36 rows=3,536 width=67) (actual time=1.338..1.338 rows=4,174 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 451kB
12. 0.550 0.550 ↓ 1.2 4,174 1

Seq Scan on diskhealthstatus dd (cost=0.00..171.36 rows=3,536 width=67) (actual time=0.002..0.550 rows=4,174 loops=1)

13. 0.291 0.291 ↑ 1.0 1 291

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

  • Index Cond: (id = bb.report_id)
Planning time : 0.900 ms
Execution time : 8.514 ms