explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qY7t : Optimization for: plan #1ocO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.592 18.467 ↑ 1.5 793 1

Sort (cost=2,298.97..2,301.85 rows=1,152 width=94) (actual time=18.455..18.467 rows=793 loops=1)

  • Sort Key: "J_measrvsn".meas
  • Sort Method: quicksort Memory: 136kB
2. 0.258 17.875 ↑ 1.5 793 1

Hash Left Join (cost=978.23..2,240.39 rows=1,152 width=94) (actual time=8.711..17.875 rows=793 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
3. 0.584 17.607 ↓ 1.0 793 1

Nested Loop Left Join (cost=956.29..2,174.63 rows=760 width=58) (actual time=8.692..17.607 rows=793 loops=1)

4. 0.539 15.437 ↓ 1.0 793 1

Nested Loop Left Join (cost=956.01..1,923.99 rows=760 width=54) (actual time=8.680..15.437 rows=793 loops=1)

5. 0.460 13.312 ↓ 1.0 793 1

Nested Loop (cost=955.72..1,671.82 rows=760 width=46) (actual time=8.671..13.312 rows=793 loops=1)

6. 0.710 11.266 ↓ 1.0 793 1

Nested Loop (cost=955.44..1,420.22 rows=760 width=50) (actual time=8.662..11.266 rows=793 loops=1)

7. 0.919 8.970 ↓ 1.0 793 1

Hash Right Join (cost=955.15..1,165.49 rows=760 width=36) (actual time=8.653..8.970 rows=793 loops=1)

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

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

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

Hash (cost=945.65..945.65 rows=760 width=32) (actual time=6.581..6.581 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
10. 0.185 6.415 ↓ 1.0 793 1

Hash Right Join (cost=926.87..945.65 rows=760 width=32) (actual time=6.235..6.415 rows=793 loops=1)

  • Hash Cond: ("F_measure_datehigh".id = "J_measrvsn".meas)
11. 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)
12. 0.234 6.226 ↓ 1.0 793 1

Hash (cost=917.22..917.22 rows=760 width=24) (actual time=6.226..6.226 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
13. 0.164 5.992 ↓ 1.0 793 1

Nested Loop (cost=303.16..917.22 rows=760 width=24) (actual time=3.852..5.992 rows=793 loops=1)

14. 1.515 4.242 ↓ 1.0 793 1

Hash Join (cost=302.87..665.91 rows=760 width=16) (actual time=3.836..4.242 rows=793 loops=1)

  • Hash Cond: ("J_msrrvsnii".info = "J_ccdainfo".info)
15. 2.334 2.334 ↑ 1.0 14,181 1

Seq Scan on "J_msrrvsnii" (cost=0.00..302.26 rows=14,181 width=8) (actual time=0.013..2.334 rows=14,181 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
16. 0.128 0.393 ↑ 1.0 806 1

Hash (cost=292.80..292.80 rows=806 width=8) (actual time=0.393..0.393 rows=806 loops=1)

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

Index Scan using optimize5 on "J_ccdainfo" (cost=0.29..292.80 rows=806 width=8) (actual time=0.016..0.265 rows=806 loops=1)

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

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

  • Index Cond: ((id = "J_msrrvsnii".info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
20. 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))
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.004 0.010 ↑ 161.5 2 1

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

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

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