explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hmoZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.163 26.976 ↑ 1.5 793 1

Merge Left Join (cost=3,043.19..3,050.74 rows=1,152 width=94) (actual time=26.783..26.976 rows=793 loops=1)

  • Merge Cond: ("ZA_measure".id = "F_measure_datehigh".id)
2. 0.796 26.799 ↑ 1.5 793 1

Sort (cost=3,012.89..3,015.77 rows=1,152 width=54) (actual time=26.766..26.799 rows=793 loops=1)

  • Sort Key: "ZA_measure".id
  • Sort Method: quicksort Memory: 136kB
3. 0.374 26.003 ↑ 1.5 793 1

Hash Left Join (cost=1,210.00..2,954.31 rows=1,152 width=54) (actual time=10.127..26.003 rows=793 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
4. 0.272 25.617 ↓ 1.0 793 1

Nested Loop Left Join (cost=1,188.06..2,888.55 rows=760 width=50) (actual time=10.107..25.617 rows=793 loops=1)

5. 0.257 22.966 ↓ 1.0 793 1

Nested Loop Left Join (cost=1,187.77..2,637.91 rows=760 width=46) (actual time=10.095..22.966 rows=793 loops=1)

6. 0.394 20.330 ↓ 1.0 793 1

Nested Loop (cost=1,187.49..2,385.74 rows=760 width=38) (actual time=10.087..20.330 rows=793 loops=1)

7. 0.135 18.350 ↓ 1.0 793 1

Nested Loop (cost=1,187.20..2,153.27 rows=760 width=38) (actual time=10.074..18.350 rows=793 loops=1)

8. 0.131 15.836 ↓ 1.0 793 1

Nested Loop Left Join (cost=1,186.92..1,902.04 rows=760 width=42) (actual time=10.066..15.836 rows=793 loops=1)

9. 0.500 13.326 ↓ 1.0 793 1

Nested Loop Left Join (cost=1,186.63..1,650.52 rows=760 width=38) (actual time=10.059..13.326 rows=793 loops=1)

10. 1.124 10.447 ↓ 1.0 793 1

Hash Right Join (cost=1,186.35..1,396.66 rows=760 width=20) (actual time=10.046..10.447 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_units".id = "ZA_msrrvsn".id)
11. 1.667 1.667 ↑ 1.0 7,995 1

Seq Scan on "F_msrrvsn_units" (cost=0.00..175.28 rows=8,182 width=8) (actual time=0.014..1.667 rows=7,995 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
12. 0.177 7.656 ↓ 1.0 793 1

Hash (cost=1,176.85..1,176.85 rows=760 width=16) (actual time=7.656..7.656 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
13. 0.167 7.479 ↓ 1.0 793 1

Hash Right Join (cost=1,162.82..1,176.85 rows=760 width=16) (actual time=7.318..7.479 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_interpret".id = "ZA_msrrvsn".id)
14. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on "F_msrrvsn_interpret" (cost=3.11..16.11 rows=240 width=4) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
15. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on "UF_msrrvsn_interpret" (cost=0.00..3.05 rows=240 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
16. 0.252 7.308 ↓ 1.0 793 1

Hash (cost=1,150.21..1,150.21 rows=760 width=16) (actual time=7.308..7.308 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
17. 0.616 7.056 ↓ 1.0 793 1

Nested Loop (cost=0.86..1,150.21 rows=760 width=16) (actual time=2.241..7.056 rows=793 loops=1)

18. 0.262 5.647 ↓ 1.0 793 1

Nested Loop (cost=0.57..917.71 rows=760 width=12) (actual time=2.228..5.647 rows=793 loops=1)

19. 0.568 3.773 ↑ 1.0 806 1

Nested Loop (cost=0.29..651.97 rows=806 width=12) (actual time=2.174..3.773 rows=806 loops=1)

20. 2.399 2.399 ↑ 1.0 806 1

Seq Scan on "J_ccdainfo" (cost=0.00..357.55 rows=806 width=8) (actual time=2.161..2.399 rows=806 loops=1)

  • Filter: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Rows Removed by Filter: 14231
21. 0.806 0.806 ↑ 1.0 1 806

Index Only Scan using "A_ccdaiteminfo_pkey" on "A_ccdaiteminfo" "ZA_ccdaiteminfo" (cost=0.29..0.37 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=806)

  • Index Cond: (id = "J_ccdainfo".info)
  • Heap Fetches: 0
22. 1.612 1.612 ↑ 1.0 1 806

Index Scan using "PJ_msrrvsnii" on "J_msrrvsnii" (cost=0.29..0.32 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=806)

  • Index Cond: ((info = "ZA_ccdaiteminfo".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
23. 0.793 0.793 ↑ 1.0 1 793

Index Only Scan using "A_msrrvsn_pkey" on "A_msrrvsn" "ZA_msrrvsn" (cost=0.29..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=793)

  • Index Cond: (id = "J_msrrvsnii".revision)
  • Heap Fetches: 0
24. 2.379 2.379 ↑ 1.0 1 793

Index Scan using "QF_ccdaiteminfo_htmlname" on "F_ccdaiteminfo_htmlname" (cost=0.29..0.32 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=793)

  • Index Cond: ((id = "ZA_ccdaiteminfo".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
25. 2.379 2.379 ↑ 1.0 1 793

Index Scan using "QF_msrrvsn_value" on "F_msrrvsn_value" (cost=0.29..0.32 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=793)

  • Index Cond: ((id = "ZA_msrrvsn".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
26. 2.379 2.379 ↑ 1.0 1 793

Index Scan using "PJ_measrvsn" on "J_measrvsn" (cost=0.29..0.32 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=793)

  • Index Cond: ((rvsn = "ZA_msrrvsn".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
27. 1.586 1.586 ↑ 1.0 1 793

Index Only Scan using "A_measure_pkey" on "A_measure" "ZA_measure" (cost=0.29..0.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=793)

  • Index Cond: (id = "J_measrvsn".meas)
  • Heap Fetches: 0
28. 2.379 2.379 ↑ 1.0 1 793

Index Scan using "QF_measure_datelow" on "F_measure_datelow" (cost=0.29..0.32 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=793)

  • Index Cond: ((id = "ZA_measure".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
29. 2.379 2.379 ↑ 1.0 1 793

Index Only Scan using "PJ_meascd" on "J_meascd" (cost=0.29..0.32 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=793)

  • Index Cond: ((meas = "ZA_measure".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
  • Heap Fetches: 793
30. 0.004 0.012 ↑ 161.5 2 1

Hash (cost=17.90..17.90 rows=323 width=8) (actual time=0.012..0.012 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.008 0.008 ↑ 161.5 2 1

Index Scan using "UF_labccd_weight" on "F_labccd_weight" (cost=0.15..17.90 rows=323 width=8) (actual time=0.006..0.008 rows=2 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
32. 0.010 0.014 ↓ 0.0 0 1

Sort (cost=30.30..31.07 rows=307 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: "F_measure_datehigh".id
  • Sort Method: quicksort Memory: 25kB
33. 0.004 0.004 ↓ 0.0 0 1

Index Scan using "UF_measure_datehigh" on "F_measure_datehigh" (cost=0.15..17.62 rows=307 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)