explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iol : Optimization for: plan #1ocO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.933 39.658 ↑ 1.0 793 1

Merge Join (cost=3,862.29..4,087.10 rows=806 width=540) (actual time=39.297..39.658 rows=793 loops=1)

  • Merge Cond: ("J_msrrvsnii".info = abc.info)
2.          

CTE abc

3. 0.118 2.676 ↑ 1.0 806 1

Sort (cost=773.19..775.21 rows=806 width=30) (actual time=2.656..2.676 rows=806 loops=1)

  • Sort Key: "J_ccdainfo".info
  • Sort Method: quicksort Memory: 87kB
4. 0.891 2.558 ↑ 1.0 806 1

Hash Join (cost=302.87..734.28 rows=806 width=30) (actual time=2.339..2.558 rows=806 loops=1)

  • Hash Cond: ("F_ccdaiteminfo_htmlname".id = "J_ccdainfo".info)
5. 1.436 1.436 ↑ 1.0 15,037 1

Seq Scan on "F_ccdaiteminfo_htmlname" (cost=0.00..366.96 rows=15,037 width=26) (actual time=0.006..1.436 rows=15,037 loops=1)

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

Hash (cost=292.80..292.80 rows=806 width=8) (actual time=0.231..0.231 rows=806 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
7. 0.158 0.158 ↑ 1.0 806 1

Index Scan using optimize5 on "J_ccdainfo" (cost=0.29..292.80 rows=806 width=8) (actual time=0.011..0.158 rows=806 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
8. 2.986 35.867 ↑ 1.0 14,156 1

Sort (cost=3,032.06..3,067.51 rows=14,181 width=16) (actual time=35.522..35.867 rows=14,156 loops=1)

  • Sort Key: "J_msrrvsnii".info
  • Sort Method: quicksort Memory: 1173kB
9. 3.786 32.881 ↑ 1.0 14,156 1

Merge Join (cost=1.14..2,054.16 rows=14,181 width=16) (actual time=0.043..32.881 rows=14,156 loops=1)

  • Merge Cond: ("F_msrrvsn_value".id = "J_measrvsn".rvsn)
10. 2.846 24.334 ↑ 1.0 14,156 1

Merge Left Join (cost=0.85..1,506.37 rows=14,181 width=20) (actual time=0.023..24.334 rows=14,156 loops=1)

  • Merge Cond: ("J_msrrvsnii".revision = "F_msrrvsn_units".id)
11. 3.770 15.815 ↑ 1.0 14,156 1

Merge Join (cost=0.57..1,101.63 rows=14,181 width=16) (actual time=0.017..15.815 rows=14,156 loops=1)

  • Merge Cond: ("J_msrrvsnii".revision = "F_msrrvsn_value".id)
12. 6.984 6.984 ↑ 1.0 14,181 1

Index Scan using optimize3 on "J_msrrvsnii" (cost=0.29..418.65 rows=14,181 width=8) (actual time=0.008..6.984 rows=14,181 loops=1)

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

Index Scan using "QF_msrrvsn_value" on "F_msrrvsn_value" (cost=0.29..470.08 rows=14,252 width=8) (actual time=0.006..5.061 rows=14,252 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
14. 5.673 5.673 ↑ 1.0 7,995 1

Index Scan using "QF_msrrvsn_units" on "F_msrrvsn_units" (cost=0.28..267.02 rows=8,182 width=8) (actual time=0.005..5.673 rows=7,995 loops=1)

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

Index Only Scan using "PJ_measrvsn" on "J_measrvsn" (cost=0.29..334.83 rows=14,277 width=4) (actual time=0.019..4.761 rows=14,277 loops=1)

  • Index Cond: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
  • Heap Fetches: 0
16. 0.087 2.858 ↑ 1.0 806 1

Sort (cost=55.03..57.04 rows=806 width=524) (actual time=2.831..2.858 rows=806 loops=1)

  • Sort Key: abc.info
  • Sort Method: quicksort Memory: 87kB
17. 2.771 2.771 ↑ 1.0 806 1

CTE Scan on abc (cost=0.00..16.12 rows=806 width=524) (actual time=2.657..2.771 rows=806 loops=1)