explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wfgS

Settings
# exclusive inclusive rows x rows loops node
1. 0.364 22.630 ↑ 1.5 793 1

Sort (cost=3,871.10..3,874.15 rows=1,222 width=94) (actual time=22.618..22.630 rows=793 loops=1)

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

CTE jci

3. 1.351 1.351 ↑ 1.0 806 1

Seq Scan on "J_ccdainfo" (cost=0.00..357.55 rows=806 width=8) (actual time=1.200..1.351 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.          

CTE jmri

5. 0.506 2.814 ↑ 1.0 793 1

Nested Loop (cost=0.29..470.21 rows=806 width=12) (actual time=1.236..2.814 rows=793 loops=1)

6. 1.502 1.502 ↑ 1.0 806 1

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

7. 0.806 0.806 ↑ 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.001 rows=1 loops=806)

  • Index Cond: ((info = jci.info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
8. 0.131 22.266 ↑ 1.5 793 1

Hash Left Join (cost=2,585.38..2,980.67 rows=1,222 width=94) (actual time=18.763..22.266 rows=793 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
9. 0.395 22.123 ↑ 1.0 793 1

Nested Loop Left Join (cost=2,563.44..2,912.26 rows=806 width=58) (actual time=18.745..22.123 rows=793 loops=1)

10. 0.908 20.935 ↑ 1.0 793 1

Hash Join (cost=2,563.15..2,646.44 rows=806 width=54) (actual time=18.737..20.935 rows=793 loops=1)

  • Hash Cond: ("ZA_measure".id = "J_measrvsn".meas)
11. 1.394 10.843 ↑ 1.0 14,277 1

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

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

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

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

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

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

  • Hash Cond: ("F_measure_datelow".id = "ZA_measure".id)
15. 2.150 2.150 ↑ 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..2.150 rows=14,277 loops=1)

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

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

  • Buckets: 16384 Batches: 1 Memory Usage: 630kB
17. 1.438 1.438 ↑ 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.012..1.438 rows=14,277 loops=1)

18. 0.165 9.184 ↑ 1.0 793 1

Hash (cost=1,629.28..1,629.28 rows=806 width=38) (actual time=9.184..9.184 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 63kB
19. 0.338 9.019 ↑ 1.0 793 1

Nested Loop (cost=346.49..1,629.28 rows=806 width=38) (actual time=5.491..9.019 rows=793 loops=1)

20. 0.333 7.888 ↑ 1.0 793 1

Nested Loop Left Join (cost=346.21..1,362.85 rows=806 width=42) (actual time=5.486..7.888 rows=793 loops=1)

21. 0.345 6.762 ↑ 1.0 793 1

Nested Loop (cost=345.92..1,096.10 rows=806 width=38) (actual time=5.480..6.762 rows=793 loops=1)

22. 0.537 5.624 ↑ 1.0 793 1

Hash Right Join (cost=345.64..556.21 rows=806 width=20) (actual time=5.472..5.624 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_units".id = "ZA_msrrvsn".id)
23. 0.870 0.870 ↑ 1.0 7,995 1

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

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

Hash (cost=335.56..335.56 rows=806 width=16) (actual time=4.217..4.217 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
25. 0.076 4.121 ↑ 1.0 793 1

Hash Right Join (cost=321.52..335.56 rows=806 width=16) (actual time=4.048..4.121 rows=793 loops=1)

  • Hash Cond: ("F_msrrvsn_interpret".id = "ZA_msrrvsn".id)
26. 0.002 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on "F_msrrvsn_interpret" (cost=3.11..16.11 rows=240 width=4) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
27. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on "UF_msrrvsn_interpret" (cost=0.00..3.05 rows=240 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
28. 0.150 4.042 ↑ 1.0 793 1

Hash (cost=308.34..308.34 rows=806 width=16) (actual time=4.042..4.042 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
29. 0.114 3.892 ↑ 1.0 793 1

Nested Loop (cost=0.29..308.34 rows=806 width=16) (actual time=1.256..3.892 rows=793 loops=1)

30. 2.985 2.985 ↑ 1.0 793 1

CTE Scan on jmri (cost=0.00..16.12 rows=806 width=12) (actual time=1.238..2.985 rows=793 loops=1)

31. 0.793 0.793 ↑ 1.0 1 793

Index Only Scan using "A_msrrvsn_pkey" on "A_msrrvsn" "ZA_msrrvsn" (cost=0.29..0.36 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=793)

  • Index Cond: (id = jmri.revision)
  • Heap Fetches: 0
32. 0.793 0.793 ↑ 1.0 1 793

Index Scan using "QF_ccdaiteminfo_htmlname" on "F_ccdaiteminfo_htmlname" (cost=0.29..0.66 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=793)

  • Index Cond: ((id = jmri.info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
33. 0.793 0.793 ↑ 1.0 1 793

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

  • Index Cond: ((id = "ZA_msrrvsn".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
34. 0.793 0.793 ↑ 1.0 1 793

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

  • Index Cond: ((rvsn = "ZA_msrrvsn".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
35. 0.793 0.793 ↑ 1.0 1 793

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

  • Index Cond: ((meas = "ZA_measure".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
  • Heap Fetches: 793
36. 0.008 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
37. 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)