explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SbQB

Settings
# exclusive inclusive rows x rows loops node
1. 0.123 7.760 ↑ 2.5 261 1

Sort (cost=1,712.55..1,714.21 rows=661 width=94) (actual time=7.754..7.760 rows=261 loops=1)

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

Hash Left Join (cost=1,059.29..1,681.59 rows=661 width=94) (actual time=5.874..7.637 rows=261 loops=1)

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

Nested Loop Left Join (cost=1,037.35..1,634.51 rows=436 width=58) (actual time=5.861..7.578 rows=261 loops=1)

4. 0.152 7.146 ↑ 1.7 261 1

Nested Loop (cost=1,037.06..1,490.72 rows=436 width=54) (actual time=5.853..7.146 rows=261 loops=1)

5. 0.168 6.733 ↑ 1.7 261 1

Nested Loop Left Join (cost=1,036.78..1,344.59 rows=436 width=40) (actual time=5.849..6.733 rows=261 loops=1)

6. 0.161 6.304 ↑ 1.7 261 1

Nested Loop (cost=1,036.49..1,199.92 rows=436 width=32) (actual time=5.844..6.304 rows=261 loops=1)

7. 0.049 5.882 ↑ 1.7 261 1

Hash Right Join (cost=1,036.21..1,054.92 rows=438 width=40) (actual time=5.839..5.882 rows=261 loops=1)

  • Hash Cond: ("F_measure_datehigh".id = "J_measrvsn".meas)
8. 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)
9. 0.052 5.831 ↑ 1.7 261 1

Hash (cost=1,030.58..1,030.58 rows=438 width=32) (actual time=5.831..5.831 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
10. 0.115 5.779 ↑ 1.7 261 1

Nested Loop (cost=675.70..1,030.58 rows=438 width=32) (actual time=5.325..5.779 rows=261 loops=1)

11. 0.584 5.403 ↑ 1.7 261 1

Hash Join (cost=675.41..885.75 rows=438 width=24) (actual time=5.316..5.403 rows=261 loops=1)

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
14. 1.023 3.619 ↓ 1.0 793 1

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

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

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

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

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

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

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

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

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=261)

  • Index Cond: ((rvsn = "J_msrrvsnii".revision) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
19. 0.261 0.261 ↑ 1.0 1 261

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=261)

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

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

  • Index Cond: ((id = "J_measrvsn".meas) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
21. 0.261 0.261 ↑ 1.0 1 261

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=261)

  • Index Cond: ((id = "J_msrrvsnii".info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
22. 0.261 0.261 ↑ 1.0 1 261

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=261)

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

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

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

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