explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m6cI

Settings
# exclusive inclusive rows x rows loops node
1. 0.186 8.610 ↑ 2.7 261 1

Sort (cost=1,924.16..1,925.92 rows=702 width=94) (actual time=8.607..8.610 rows=261 loops=1)

  • Sort Key: "J_measrvsn".meas
  • Sort Method: quicksort Memory: 61kB
2.          

CTE jci

3. 1.549 1.549 ↑ 1.0 806 1

Seq Scan on "J_ccdainfo" (cost=0.00..357.55 rows=806 width=8) (actual time=1.349..1.549 rows=806 loops=1)

  • Filter: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Rows Removed by Filter: 14231
4. 0.056 8.424 ↑ 2.7 261 1

Hash Left Join (cost=873.70..1,533.42 rows=702 width=94) (actual time=6.214..8.424 rows=261 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
5. 0.015 8.360 ↑ 1.8 261 1

Nested Loop Left Join (cost=851.76..1,484.78 rows=463 width=58) (actual time=6.200..8.360 rows=261 loops=1)

6. 0.236 7.823 ↑ 1.8 261 1

Nested Loop Left Join (cost=851.47..1,332.09 rows=463 width=54) (actual time=6.191..7.823 rows=261 loops=1)

7. 0.000 7.326 ↑ 1.8 261 1

Nested Loop (cost=851.19..1,178.46 rows=463 width=46) (actual time=6.186..7.326 rows=261 loops=1)

8. 0.088 6.835 ↑ 1.8 261 1

Nested Loop (cost=850.90..1,023.28 rows=463 width=32) (actual time=6.182..6.835 rows=261 loops=1)

9. 0.055 6.225 ↑ 1.8 261 1

Hash Right Join (cost=850.62..869.34 rows=465 width=40) (actual time=6.177..6.225 rows=261 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.064 6.168 ↑ 1.8 261 1

Hash (cost=844.65..844.65 rows=465 width=32) (actual time=6.168..6.168 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
12. 0.081 6.104 ↑ 1.8 261 1

Nested Loop (cost=480.57..844.65 rows=465 width=32) (actual time=5.371..6.104 rows=261 loops=1)

13. 0.822 5.501 ↑ 1.8 261 1

Hash Join (cost=480.29..690.89 rows=465 width=24) (actual time=5.365..5.501 rows=261 loops=1)

  • Hash Cond: ("F_msrrvsn_units".id = "J_msrrvsnii".revision)
14. 1.279 1.279 ↑ 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.279 rows=7,995 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
15. 0.183 3.400 ↑ 1.0 793 1

Hash (cost=470.21..470.21 rows=806 width=16) (actual time=3.400..3.400 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
16. 0.000 3.217 ↑ 1.0 793 1

Nested Loop (cost=0.29..470.21 rows=806 width=16) (actual time=1.380..3.217 rows=793 loops=1)

17. 1.719 1.719 ↑ 1.0 806 1

CTE Scan on jci (cost=0.00..16.12 rows=806 width=8) (actual time=1.351..1.719 rows=806 loops=1)

18. 1.612 1.612 ↑ 1.0 1 806

Index Scan using optimize2 on "J_msrrvsnii" (cost=0.29..0.55 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=806)

  • Index Cond: ((info = jci.info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
19. 0.522 0.522 ↑ 1.0 1 261

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

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

  • Index Cond: ((id = "J_msrrvsnii".revision) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
21. 0.522 0.522 ↑ 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.002 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 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))
23. 0.522 0.522 ↑ 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.002..0.002 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
24. 0.002 0.008 ↑ 161.5 2 1

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

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

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