explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g0kS

Settings
# exclusive inclusive rows x rows loops node
1. 0.108 7.438 ↑ 2.5 261 1

Sort (cost=1,791.81..1,793.47 rows=661 width=94) (actual time=7.432..7.438 rows=261 loops=1)

  • Sort Key: "J_measrvsn".meas
  • Sort Method: quicksort Memory: 61kB
2. 0.040 7.330 ↑ 2.5 261 1

Hash Left Join (cost=785.00..1,760.85 rows=661 width=94) (actual time=5.335..7.330 rows=261 loops=1)

  • Hash Cond: ("J_meascd".code = "F_labccd_weight".id)
3. 0.110 7.282 ↑ 1.7 261 1

Nested Loop Left Join (cost=763.06..1,713.77 rows=436 width=58) (actual time=5.323..7.282 rows=261 loops=1)

4. 0.051 6.911 ↑ 1.7 261 1

Hash Left Join (cost=762.77..1,569.98 rows=436 width=54) (actual time=5.317..6.911 rows=261 loops=1)

  • Hash Cond: ("J_measrvsn".meas = "F_measure_datehigh".id)
5. 0.119 6.858 ↑ 1.7 261 1

Nested Loop Left Join (cost=741.31..1,530.45 rows=436 width=46) (actual time=5.308..6.858 rows=261 loops=1)

6. 0.098 6.478 ↑ 1.7 261 1

Nested Loop (cost=741.03..1,385.78 rows=436 width=38) (actual time=5.304..6.478 rows=261 loops=1)

7. 0.105 6.119 ↑ 1.7 261 1

Nested Loop (cost=740.74..1,241.64 rows=436 width=46) (actual time=5.298..6.119 rows=261 loops=1)

8. 0.116 5.753 ↑ 1.7 261 1

Nested Loop (cost=740.46..1,095.51 rows=436 width=32) (actual time=5.293..5.753 rows=261 loops=1)

9. 0.471 5.376 ↑ 1.7 261 1

Hash Join (cost=740.17..950.51 rows=438 width=24) (actual time=5.283..5.376 rows=261 loops=1)

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

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

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

Hash (cost=730.67..730.67 rows=760 width=16) (actual time=4.088..4.088 rows=793 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
12. 0.925 3.930 ↓ 1.0 793 1

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

  • Hash Cond: ("J_msrrvsnii".info = "J_ccdainfo".info)
13. 1.344 1.344 ↑ 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.344 rows=14,181 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
15. 1.569 1.569 ↑ 1.0 806 1

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

  • Filter: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Rows Removed by Filter: 14231
16. 0.261 0.261 ↑ 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.001..0.001 rows=1 loops=261)

  • Index Cond: ((id = "J_msrrvsnii".revision) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
17. 0.261 0.261 ↑ 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.001 rows=1 loops=261)

  • Index Cond: ((id = "J_msrrvsnii".info) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
18. 0.261 0.261 ↑ 1.0 1 261

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

  • Index Cond: ((rvsn = "F_msrrvsn_value".id) AND ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone))
19. 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))
20. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=17.62..17.62 rows=307 width=12) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
21. 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)
22. 0.261 0.261 ↑ 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.001..0.001 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
23. 0.003 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
24. 0.005 0.005 ↑ 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.005 rows=2 loops=1)

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