explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v5Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.901 38.499 ↑ 2.7 261 1

Sort (cost=2,754.60..2,756.36 rows=702 width=94) (actual time=38.488..38.499 rows=261 loops=1)

  • Sort Key: "ZA_measure".id
  • Sort Method: quicksort Memory: 61kB
2.          

CTE jci

3. 2.687 2.687 ↑ 1.0 806 1

Seq Scan on "J_ccdainfo" (cost=0.00..357.55 rows=806 width=8) (actual time=2.423..2.687 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.139 37.598 ↑ 2.7 261 1

Hash Left Join (cost=2,104.89..2,363.86 rows=702 width=94) (actual time=31.457..37.598 rows=261 loops=1)

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

Nested Loop Left Join (cost=2,082.95..2,315.22 rows=463 width=58) (actual time=31.422..37.434 rows=261 loops=1)

6. 1.474 35.471 ↑ 1.8 261 1

Hash Join (cost=2,082.66..2,162.53 rows=463 width=54) (actual time=31.404..35.471 rows=261 loops=1)

  • Hash Cond: ("ZA_measure".id = "J_measrvsn".meas)
7. 2.737 23.520 ↑ 1.0 14,277 1

Hash Right Join (cost=923.80..945.49 rows=14,277 width=20) (actual time=20.881..23.520 rows=14,277 loops=1)

  • Hash Cond: ("F_measure_datehigh".id = "ZA_measure".id)
8. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
9. 3.886 20.776 ↑ 1.0 14,277 1

Hash (cost=745.18..745.18 rows=14,277 width=12) (actual time=20.775..20.776 rows=14,277 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 798kB
10. 6.140 16.890 ↑ 1.0 14,277 1

Hash Right Join (cost=388.23..745.18 rows=14,277 width=12) (actual time=6.419..16.890 rows=14,277 loops=1)

  • Hash Cond: ("F_measure_datelow".id = "ZA_measure".id)
11. 4.821 4.821 ↑ 1.0 14,277 1

Seq Scan on "F_measure_datelow" (cost=0.00..319.46 rows=14,277 width=12) (actual time=0.010..4.821 rows=14,277 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
12. 3.110 5.929 ↑ 1.0 14,277 1

Hash (cost=209.77..209.77 rows=14,277 width=4) (actual time=5.929..5.929 rows=14,277 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 630kB
13. 2.819 2.819 ↑ 1.0 14,277 1

Seq Scan on "A_measure" "ZA_measure" (cost=0.00..209.77 rows=14,277 width=4) (actual time=0.013..2.819 rows=14,277 loops=1)

14. 0.131 10.477 ↑ 1.8 261 1

Hash (cost=1,153.08..1,153.08 rows=463 width=38) (actual time=10.477..10.477 rows=261 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
15. 0.248 10.346 ↑ 1.8 261 1

Nested Loop (cost=481.14..1,153.08 rows=463 width=38) (actual time=7.886..10.346 rows=261 loops=1)

16. 0.221 9.576 ↑ 1.8 261 1

Nested Loop (cost=480.86..1,000.02 rows=463 width=46) (actual time=7.879..9.576 rows=261 loops=1)

17. 0.230 8.833 ↑ 1.8 261 1

Nested Loop (cost=480.57..844.83 rows=463 width=32) (actual time=7.870..8.833 rows=261 loops=1)

18. 1.022 8.081 ↑ 1.8 261 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
21. 0.606 5.137 ↑ 1.0 793 1

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

22. 2.919 2.919 ↑ 1.0 806 1

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

23. 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.002..0.002 rows=1 loops=806)

  • Index Cond: ((info = jci.info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
24. 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))
25. 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.002..0.002 rows=1 loops=261)

  • Index Cond: ((id = "J_msrrvsnii".info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
26. 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 = "F_msrrvsn_value".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
27. 1.827 1.827 ↑ 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.006..0.007 rows=1 loops=261)

  • Index Cond: ((meas = "ZA_measure".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
  • Heap Fetches: 261
28. 0.017 0.025 ↑ 161.5 2 1

Hash (cost=17.90..17.90 rows=323 width=8) (actual time=0.025..0.025 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.006..0.008 rows=2 loops=1)

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