explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wmY6 : Optimization for: plan #rHKl

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 108,426.402 ↑ 1.0 1 1

Nested Loop (cost=244,542.92..244,564.6 rows=1 width=45) (actual time=108,426.384..108,426.402 rows=1 loops=1)

  • Buffers: shared hit=113406 read=42553
2. 1.120 108,426.169 ↑ 1.0 1 1

Aggregate (cost=244,538.33..244,538.34 rows=1 width=0) (actual time=108,426.168..108,426.169 rows=1 loops=1)

  • Buffers: shared hit=113396 read=42553
3. 1,109.656 108,425.049 ↓ 7.0 1,246 1

Hash Join (cost=79,283.31..244,537.88 rows=179 width=0) (actual time=106,450.725..108,425.049 rows=1,246 loops=1)

  • Buffers: shared hit=113396 read=42553
4. 106,555.291 106,986.514 ↓ 3.0 171,985 1

Bitmap Heap Scan on a11mfs tbl_a2 (cost=1,932.24..166,458.6 rows=58,115 width=4) (actual time=456.696..106,986.514 rows=171,985 loops=1)

  • Buffers: shared hit=4834 read=42525
5. 431.223 431.223 ↓ 3.0 171,985 1

Bitmap Index Scan on a11mfs3 (cost=0..1,917.72 rows=58,115 width=0) (actual time=431.223..431.223 rows=171,985 loops=1)

  • Index Cond: ((tbl_a2.fldid = 19) AND ((tbl_a2.value)::text = '008081457-CODIGOCESCE'::text))
  • Buffers: shared hit=1 read=1064
6. 94.130 328.879 ↓ 2.0 137,940 1

Hash (cost=76,484.02..76,484.02 rows=69,363 width=4) (actual time=328.879..328.879 rows=137,940 loops=1)

  • Buffers: shared hit=108562 read=28
7. 234.749 234.749 ↓ 2.0 137,940 1

Index Scan using a11sf2 on a11sf tbl_a1 (cost=0.44..76,484.02 rows=69,363 width=4) (actual time=21.339..234.749 rows=137,940 loops=1)

  • Index Cond: ((tbl_a1.fld1 >= to_timestamp('2019-10-26 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text)) AND (tbl_a1.fld1 <= to_timestamp('2019-11-25 23:59:59'::text, 'YYYY-MM-DD HH24:MI:SS'::text)))
  • Buffers: shared hit=108562 read=28
8. 0.078 0.220 ↑ 1.0 1 1

Nested Loop (cost=4.59..26.24 rows=1 width=37) (actual time=0.204..0.22 rows=1 loops=1)

  • Buffers: shared hit=10
9. 0.043 0.043 ↑ 1.0 1 1

Index Scan using idocvldtbl22i0 on idocvldtbl22 tbl_b (cost=0.28..8.29 rows=1 width=4) (actual time=0.042..0.043 rows=1 loops=1)

  • Index Cond: ('SUCLA001'::text = (tbl_b.idocval)::text)
  • Buffers: shared hit=3
10. 0.057 0.099 ↑ 1.0 1 1

Bitmap Heap Scan on idocvldsubs22 tbl_c (cost=4.32..17.94 rows=1 width=41) (actual time=0.086..0.099 rows=1 loops=1)

  • Filter: ((tbl_c.locale)::text = 'es'::text)
  • Buffers: shared hit=7
11. 0.042 0.042 ↑ 1.0 5 1

Bitmap Index Scan on idocvldsubs22i0 (cost=0..4.32 rows=5 width=0) (actual time=0.042..0.042 rows=5 loops=1)

  • Index Cond: (tbl_c.idocid = tbl_b.idocid)
  • Buffers: shared hit=2
Total runtime : 108,426.549 ms