explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f6ht

Settings
# exclusive inclusive rows x rows loops node
1. 0.392 22.854 ↑ 1.5 793 1

Sort (cost=3,539.58..3,542.64 rows=1,222 width=94) (actual time=22.825..22.854 rows=793 loops=1)

  • Sort Key: "ZA_measure".id
  • Sort Method: quicksort Memory: 136kB
2.          

CTE jci

3. 1.270 1.270 ↑ 1.0 806 1

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

  • Filter: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Rows Removed by Filter: 14231
4. 0.121 22.462 ↑ 1.5 793 1

Hash Left Join (cost=2,724.07..3,119.37 rows=1,222 width=94) (actual time=18.971..22.462 rows=793 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
5. 0.392 22.326 ↑ 1.0 793 1

Nested Loop Left Join (cost=2,702.13..3,050.95 rows=806 width=58) (actual time=18.950..22.326 rows=793 loops=1)

6. 0.933 21.141 ↑ 1.0 793 1

Hash Join (cost=2,701.85..2,785.14 rows=806 width=54) (actual time=18.942..21.141 rows=793 loops=1)

  • Hash Cond: ("ZA_measure".id = "J_measrvsn".meas)
7. 1.349 11.154 ↑ 1.0 14,277 1

Hash Right Join (cost=923.80..945.49 rows=14,277 width=20) (actual time=9.871..11.154 rows=14,277 loops=1)

  • Hash Cond: ("F_measure_datehigh".id = "ZA_measure".id)
8. 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)
9. 1.589 9.801 ↑ 1.0 14,277 1

Hash (cost=745.18..745.18 rows=14,277 width=12) (actual time=9.801..9.801 rows=14,277 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 798kB
10. 2.906 8.212 ↑ 1.0 14,277 1

Hash Right Join (cost=388.23..745.18 rows=14,277 width=12) (actual time=3.192..8.212 rows=14,277 loops=1)

  • Hash Cond: ("F_measure_datelow".id = "ZA_measure".id)
11. 2.193 2.193 ↑ 1.0 14,277 1

Seq Scan on "F_measure_datelow" (cost=0.00..319.46 rows=14,277 width=12) (actual time=0.007..2.193 rows=14,277 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
12. 1.541 3.113 ↑ 1.0 14,277 1

Hash (cost=209.77..209.77 rows=14,277 width=4) (actual time=3.113..3.113 rows=14,277 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 630kB
13. 1.572 1.572 ↑ 1.0 14,277 1

Seq Scan on "A_measure" "ZA_measure" (cost=0.00..209.77 rows=14,277 width=4) (actual time=0.007..1.572 rows=14,277 loops=1)

14. 0.168 9.054 ↑ 1.0 793 1

Hash (cost=1,767.98..1,767.98 rows=806 width=38) (actual time=9.054..9.054 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 63kB
15. 0.475 8.886 ↑ 1.0 793 1

Nested Loop (cost=754.93..1,767.98 rows=806 width=38) (actual time=4.891..8.886 rows=793 loops=1)

16. 0.460 7.618 ↑ 1.0 793 1

Nested Loop Left Join (cost=754.65..1,501.54 rows=806 width=42) (actual time=4.886..7.618 rows=793 loops=1)

17. 0.531 6.365 ↑ 1.0 793 1

Nested Loop (cost=754.36..1,234.80 rows=806 width=38) (actual time=4.880..6.365 rows=793 loops=1)

18. 0.568 5.041 ↑ 1.0 793 1

Hash Right Join (cost=754.08..964.65 rows=806 width=24) (actual time=4.872..5.041 rows=793 loops=1)

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

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

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
20. 0.103 3.637 ↑ 1.0 793 1

Hash (cost=744.00..744.00 rows=806 width=20) (actual time=3.637..3.637 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
21. 0.094 3.534 ↑ 1.0 793 1

Hash Right Join (cost=729.96..744.00 rows=806 width=20) (actual time=3.445..3.534 rows=793 loops=1)

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

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

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

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

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
24. 0.125 3.437 ↑ 1.0 793 1

Hash (cost=716.78..716.78 rows=806 width=20) (actual time=3.437..3.437 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
25. 0.015 3.312 ↑ 1.0 793 1

Nested Loop (cost=0.57..716.78 rows=806 width=20) (actual time=1.198..3.312 rows=793 loops=1)

26. 0.283 2.504 ↑ 1.0 793 1

Nested Loop (cost=0.29..470.21 rows=806 width=16) (actual time=1.188..2.504 rows=793 loops=1)

27. 1.415 1.415 ↑ 1.0 806 1

CTE Scan on jci (cost=0.00..16.12 rows=806 width=8) (actual time=1.162..1.415 rows=806 loops=1)

28. 0.806 0.806 ↑ 1.0 1 806

Index Scan using optimize2 on "J_msrrvsnii" (cost=0.29..0.55 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=806)

  • Index Cond: ((info = jci.info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
29. 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
30. 0.793 0.793 ↑ 1.0 1 793

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

  • Index Cond: ((id = "J_msrrvsnii".info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
31. 0.793 0.793 ↑ 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.001..0.001 rows=1 loops=793)

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

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

  • Index Cond: ((rvsn = "ZA_msrrvsn".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
33. 0.793 0.793 ↑ 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.001..0.001 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
34. 0.010 0.015 ↑ 161.5 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.005 0.005 ↑ 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.004..0.005 rows=2 loops=1)

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