explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O7EI : Optimization for: plan #1ocO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.075 16.139 ↑ 2.5 261 1

Sort (cost=2,915.56..2,917.21 rows=661 width=94) (actual time=16.133..16.139 rows=261 loops=1)

  • Sort Key: "J_measrvsn".meas
  • Sort Method: quicksort Memory: 61kB
2. 0.041 16.064 ↑ 2.5 261 1

Hash Left Join (cost=2,504.10..2,884.60 rows=661 width=94) (actual time=15.867..16.064 rows=261 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
3. 0.758 16.011 ↑ 1.7 261 1

Hash Right Join (cost=2,482.16..2,837.52 rows=436 width=58) (actual time=15.843..16.011 rows=261 loops=1)

  • Hash Cond: ("J_meascd".meas = "J_measrvsn".meas)
4. 1.443 1.443 ↑ 1.0 14,277 1

Seq Scan on "J_meascd" (cost=0.00..297.46 rows=14,277 width=8) (actual time=0.008..1.443 rows=14,277 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
5. 0.050 13.810 ↑ 1.7 261 1

Hash (cost=2,476.71..2,476.71 rows=436 width=54) (actual time=13.810..13.810 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
6. 0.823 13.760 ↑ 1.7 261 1

Hash Join (cost=2,049.00..2,476.71 rows=436 width=54) (actual time=13.576..13.760 rows=261 loops=1)

  • Hash Cond: ("F_ccdaiteminfo_htmlname".id = "J_msrrvsnii".info)
7. 1.476 1.476 ↑ 1.0 15,037 1

Seq Scan on "F_ccdaiteminfo_htmlname" (cost=0.00..366.96 rows=15,037 width=26) (actual time=0.010..1.476 rows=15,037 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
8. 0.046 11.461 ↑ 1.7 261 1

Hash (cost=2,043.55..2,043.55 rows=436 width=40) (actual time=11.461..11.461 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
9. 0.759 11.415 ↑ 1.7 261 1

Hash Right Join (cost=1,666.19..2,043.55 rows=436 width=40) (actual time=11.233..11.415 rows=261 loops=1)

  • Hash Cond: ("F_measure_datelow".id = "J_measrvsn".meas)
10. 1.358 1.358 ↑ 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..1.358 rows=14,277 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
11. 0.048 9.298 ↑ 1.7 261 1

Hash (cost=1,660.74..1,660.74 rows=436 width=32) (actual time=9.298..9.298 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
12. 0.776 9.250 ↑ 1.7 261 1

Hash Join (cost=1,293.76..1,660.74 rows=436 width=32) (actual time=9.079..9.250 rows=261 loops=1)

  • Hash Cond: ("F_msrrvsn_value".id = "J_msrrvsnii".revision)
13. 1.424 1.424 ↑ 1.0 14,252 1

Seq Scan on "F_msrrvsn_value" (cost=0.00..309.15 rows=14,252 width=8) (actual time=0.003..1.424 rows=14,252 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
14. 0.047 7.050 ↑ 1.7 261 1

Hash (cost=1,288.29..1,288.29 rows=438 width=40) (actual time=7.050..7.050 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
15. 0.555 7.003 ↑ 1.7 261 1

Hash Join (cost=1,077.95..1,288.29 rows=438 width=40) (actual time=6.914..7.003 rows=261 loops=1)

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

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

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

Hash (cost=1,068.45..1,068.45 rows=760 width=32) (actual time=5.562..5.562 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
18. 0.088 5.450 ↓ 1.0 793 1

Hash Right Join (cost=1,049.66..1,068.45 rows=760 width=32) (actual time=5.367..5.450 rows=793 loops=1)

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

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

Hash (cost=1,040.01..1,040.01 rows=760 width=24) (actual time=5.359..5.359 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
21. 1.073 5.226 ↓ 1.0 793 1

Hash Join (cost=675.41..1,040.01 rows=760 width=24) (actual time=4.994..5.226 rows=793 loops=1)

  • Hash Cond: ("J_measrvsn".rvsn = "J_msrrvsnii".revision)
22. 1.568 1.568 ↑ 1.0 14,277 1

Seq Scan on "J_measrvsn" (cost=0.00..303.46 rows=14,277 width=8) (actual time=0.003..1.568 rows=14,277 loops=1)

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

Hash (cost=665.91..665.91 rows=760 width=16) (actual time=2.585..2.585 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
24. 0.879 2.480 ↓ 1.0 793 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
27. 0.173 0.173 ↑ 1.0 806 1

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

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
28. 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
29. 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.008..0.008 rows=2 loops=1)

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