explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SZr7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=913.92..2,201.99 rows=1,178 width=74) (actual rows= loops=)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=891.98..2,135.25 rows=777 width=70) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=891.69..1,879.01 rows=777 width=62) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=891.41..1,621.42 rows=777 width=54) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=891.12..1,364.52 rows=777 width=54) (actual rows= loops=)

  • Join Filter: ("J_ccdainfo".info = "F_ccdaiteminfo_htmlname".id)
6. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=890.84..1,104.66 rows=777 width=36) (actual rows= loops=)

  • Hash Cond: ("F_msrrvsn_units".id = "J_msrrvsnii".revision)
7. 0.000 0.000 ↓ 0.0

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

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
8. 0.000 0.000 ↓ 0.0

Hash (cost=881.12..881.12 rows=777 width=32) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=862.34..881.12 rows=777 width=32) (actual rows= loops=)

  • Hash Cond: ("F_measure_datehigh".id = "J_measrvsn".meas)
10. 0.000 0.000 ↓ 0.0

Index Scan using "UF_measure_datehigh" on "F_measure_datehigh" (cost=0.15..17.62 rows=307 width=12) (actual rows= loops=)

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

Hash (cost=852.48..852.48 rows=777 width=24) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=324.50..852.48 rows=777 width=24) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=324.22..597.87 rows=777 width=16) (actual rows= loops=)

  • Hash Cond: ("J_msrrvsnii".info = "J_ccdainfo".info)
14. 0.000 0.000 ↓ 0.0

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

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
15. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) = true)
16. 0.000 0.000 ↓ 0.0

Hash (cost=232.57..232.57 rows=825 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
18. 0.000 0.000 ↓ 0.0

Index Scan using "XJ_measrvsn_FM_rvsn_TO_meas2" on "J_measrvsn" (cost=0.29..0.32 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (rvsn = "J_msrrvsnii".revision)
  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
19. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = "J_msrrvsnii".info)
  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
20. 0.000 0.000 ↓ 0.0

Index Scan using optimize13 on "F_msrrvsn_value" (cost=0.29..0.32 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) = true) AND (id = "J_msrrvsnii".revision))
  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
21. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((id = "J_measrvsn".meas) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
22. 0.000 0.000 ↓ 0.0

Index Only Scan using "PJ_meascd" on "J_meascd" (cost=0.29..0.32 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((meas = "J_measrvsn".meas) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
23. 0.000 0.000 ↓ 0.0

Hash (cost=17.90..17.90 rows=323 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Index Scan using "UF_labccd_weight" on "F_labccd_weight" (cost=0.15..17.90 rows=323 width=8) (actual rows= loops=)

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