explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gmBr

Settings
# exclusive inclusive rows x rows loops node
1. 36.490 255,904.099 ↑ 1.8 24 1

Nested Loop (cost=23,580.75..45,188.86 rows=43 width=6) (actual time=6,190.438..255,904.099 rows=24 loops=1)

2. 24.320 4,750.879 ↑ 2.9 9,754 1

HashAggregate (cost=23,580.19..23,858.89 rows=27,870 width=6) (actual time=4,732.395..4,750.879 rows=9,754 loops=1)

  • Group Key: uchast.delo_id
3. 2.167 4,726.559 ↑ 2.9 9,754 1

Nested Loop (cost=5.20..23,510.52 rows=27,870 width=6) (actual time=27.311..4,726.559 rows=9,754 loops=1)

4. 27.520 54.769 ↓ 1.2 279 1

Bitmap Heap Scan on kart_ul (cost=4.64..278.54 rows=234 width=6) (actual time=27.282..54.769 rows=279 loops=1)

  • Recheck Cond: ((inn)::text = '7724261610'::text)
  • Heap Blocks: exact=253
5. 27.249 27.249 ↓ 1.2 279 1

Bitmap Index Scan on kart_ul_inn (cost=0.00..4.58 rows=234 width=0) (actual time=27.249..27.249 rows=279 loops=1)

  • Index Cond: ((inn)::text = '7724261610'::text)
6. 4,669.623 4,669.623 ↑ 3.4 35 279

Index Scan using uchast_ul_id on uchast (cost=0.56..98.09 rows=119 width=13) (actual time=13.354..16.737 rows=35 loops=279)

  • Index Cond: (ul_id = kart_ul.id)
  • Filter: (uchast_vid = '1'::numeric)
  • Rows Removed by Filter: 0
7. 251,116.730 251,116.730 ↓ 0.0 0 9,754

Index Scan using delo_pkey on delo (cost=0.56..0.76 rows=1 width=6) (actual time=25.745..25.745 rows=0 loops=9,754)

  • Index Cond: (delo_id = uchast.delo_id)
  • Filter: ((delo_dat >= '2020-07-01 00:00:00'::timestamp without time zone) AND (delo_dat <= '2020-07-30 23:59:59'::timestamp without time zone) AND ((ogai_nah_kod)::text = '45597'::text) AND ((stad_delo_kod = '1'::numeric) OR (stad_delo_kod = '2'::numeric) OR (stad_delo_kod = '5'::numeric) OR (stad_delo_kod = '3'::numeric)))
  • Rows Removed by Filter: 1
Planning time : 0.553 ms
Execution time : 255,909.172 ms