explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pLLD

Settings
# exclusive inclusive rows x rows loops node
1. 0.168 13.114 ↑ 1.5 793 1

Hash Left Join (cost=913.92..2,186.52 rows=1,159 width=94) (actual time=6.405..13.114 rows=793 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
2. 0.015 12.933 ↓ 1.0 793 1

Nested Loop Left Join (cost=891.98..2,120.52 rows=764 width=58) (actual time=6.387..12.933 rows=793 loops=1)

3. 0.000 11.332 ↓ 1.0 793 1

Nested Loop Left Join (cost=891.69..1,868.56 rows=764 width=54) (actual time=6.332..11.332 rows=793 loops=1)

4. 0.043 9.797 ↓ 1.0 793 1

Nested Loop Left Join (cost=891.41..1,615.28 rows=764 width=46) (actual time=6.327..9.797 rows=793 loops=1)

5. 0.043 8.168 ↓ 1.0 793 1

Nested Loop (cost=891.12..1,361.69 rows=764 width=28) (actual time=6.322..8.168 rows=793 loops=1)

6. 0.601 6.539 ↓ 1.0 793 1

Hash Right Join (cost=890.84..1,104.66 rows=777 width=32) (actual time=6.314..6.539 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_units".id = "J_msrrvsnii".revision)
7. 0.854 0.854 ↑ 1.0 8,270 1

Seq Scan on "F_msrrvsn_units" (cost=0.00..178.38 rows=8,270 width=8) (actual time=0.008..0.854 rows=8,270 loops=1)

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

Hash (cost=881.12..881.12 rows=777 width=28) (actual time=5.084..5.084 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
9. 0.085 4.977 ↓ 1.0 793 1

Hash Right Join (cost=862.34..881.12 rows=777 width=28) (actual time=4.896..4.977 rows=793 loops=1)

  • Hash Cond: ("F_measure_datehigh".id = "J_measrvsn".meas)
10. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

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

Hash (cost=852.48..852.48 rows=777 width=20) (actual time=4.890..4.890 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
12. 0.297 4.737 ↓ 1.0 793 1

Nested Loop (cost=324.50..852.48 rows=777 width=20) (actual time=3.381..4.737 rows=793 loops=1)

13. 1.019 3.647 ↓ 1.0 793 1

Hash Join (cost=324.22..597.87 rows=777 width=12) (actual time=3.373..3.647 rows=793 loops=1)

  • Hash Cond: ("J_msrrvsnii".info = "J_ccdainfo".info)
14. 1.856 2.394 ↑ 1.0 14,488 1

Bitmap Heap Scan on "J_msrrvsnii" (cost=81.34..292.89 rows=14,488 width=8) (actual time=0.561..2.394 rows=14,488 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
  • Heap Blocks: exact=121
15. 0.538 0.538 ↓ 2.0 14,488 1

Bitmap Index Scan on optimize8 (cost=0.00..77.72 rows=7,244 width=0) (actual time=0.538..0.538 rows=14,488 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) = true)
16. 0.085 0.234 ↑ 1.0 806 1

Hash (cost=232.57..232.57 rows=825 width=8) (actual time=0.234..0.234 rows=806 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
17. 0.149 0.149 ↑ 1.0 806 1

Index Only Scan using optimize9 on "J_ccdainfo" (cost=0.29..232.57 rows=825 width=8) (actual time=0.031..0.149 rows=806 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Heap Fetches: 98
18. 0.793 0.793 ↑ 1.0 1 793

Index Scan using "XJ_measrvsn_FM_rvsn_TO_meas2" 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 = "J_msrrvsnii".revision)
  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
19. 1.586 1.586 ↑ 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.002 rows=1 loops=793)

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

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

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

  • Index Cond: ((id = "J_measrvsn".meas) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
22. 1.586 1.586 ↑ 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.002 rows=1 loops=793)

  • Index Cond: ((meas = "J_measrvsn".meas) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
  • Heap Fetches: 793
23. 0.005 0.013 ↑ 161.5 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 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.007..0.008 rows=2 loops=1)

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