explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7V9g

Settings
# exclusive inclusive rows x rows loops node
1. 0.406 22.730 ↑ 1.5 793 1

Sort (cost=3,360.11..3,362.99 rows=1,152 width=94) (actual time=22.718..22.730 rows=793 loops=1)

  • Sort Key: "ZA_measure".id
  • Sort Method: quicksort Memory: 136kB
2. 0.124 22.324 ↑ 1.5 793 1

Hash Left Join (cost=2,924.52..3,301.53 rows=1,152 width=94) (actual time=18.816..22.324 rows=793 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
3. 0.429 22.186 ↓ 1.0 793 1

Nested Loop Left Join (cost=2,902.58..3,235.77 rows=760 width=58) (actual time=18.795..22.186 rows=793 loops=1)

4. 0.932 20.964 ↓ 1.0 793 1

Hash Join (cost=2,902.30..2,985.13 rows=760 width=54) (actual time=18.786..20.964 rows=793 loops=1)

  • Hash Cond: ("ZA_measure".id = "J_measrvsn".meas)
5. 1.361 10.186 ↑ 1.0 14,277 1

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

  • Hash Cond: ("F_measure_datehigh".id = "ZA_measure".id)
6. 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)
7. 1.504 8.821 ↑ 1.0 14,277 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 798kB
8. 2.716 7.317 ↑ 1.0 14,277 1

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

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

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

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

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

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

12. 0.169 9.846 ↓ 1.0 793 1

Hash (cost=1,969.00..1,969.00 rows=760 width=38) (actual time=9.846..9.846 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 63kB
13. 0.322 9.677 ↓ 1.0 793 1

Nested Loop (cost=1,000.16..1,969.00 rows=760 width=38) (actual time=6.114..9.677 rows=793 loops=1)

14. 0.371 8.562 ↓ 1.0 793 1

Nested Loop Left Join (cost=999.88..1,717.77 rows=760 width=42) (actual time=6.109..8.562 rows=793 loops=1)

15. 0.327 7.398 ↓ 1.0 793 1

Nested Loop (cost=999.59..1,466.25 rows=760 width=38) (actual time=6.104..7.398 rows=793 loops=1)

  • Join Filter: ("J_ccdainfo".info = "F_ccdaiteminfo_htmlname".id)
16. 0.575 6.278 ↓ 1.0 793 1

Hash Right Join (cost=999.31..1,209.62 rows=760 width=24) (actual time=6.097..6.278 rows=793 loops=1)

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

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

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

Hash (cost=989.81..989.81 rows=760 width=20) (actual time=4.861..4.861 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
19. 0.088 4.756 ↓ 1.0 793 1

Hash Right Join (cost=975.78..989.81 rows=760 width=20) (actual time=4.671..4.756 rows=793 loops=1)

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

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

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

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

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
22. 0.132 4.666 ↓ 1.0 793 1

Hash (cost=963.17..963.17 rows=760 width=20) (actual time=4.666..4.666 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
23. 0.000 4.534 ↓ 1.0 793 1

Nested Loop (cost=367.91..963.17 rows=760 width=20) (actual time=3.588..4.534 rows=793 loops=1)

24. 0.868 3.800 ↓ 1.0 793 1

Hash Join (cost=367.63..730.67 rows=760 width=16) (actual time=3.576..3.800 rows=793 loops=1)

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

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

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

Hash (cost=357.55..357.55 rows=806 width=8) (actual time=1.644..1.644 rows=806 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
27. 1.520 1.520 ↑ 1.0 806 1

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

  • Filter: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Rows Removed by Filter: 14231
28. 0.793 0.793 ↑ 1.0 1 793

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

  • Index Cond: (id = "J_msrrvsnii".revision)
  • Heap Fetches: 0
29. 0.793 0.793 ↑ 1.0 1 793

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

  • Index Cond: ((id = "J_msrrvsnii".info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
30. 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))
31. 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))
32. 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
33. 0.010 0.014 ↑ 161.5 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 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)