explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h1DJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2,314.968 ↓ 55.0 55 1

Limit (cost=38,117.04..38,117.07 rows=1 width=59) (actual time=2,314.774..2,314.968 rows=55 loops=1)

2. 0.194 2,314.960 ↓ 55.0 55 1

GroupAggregate (cost=38,117.04..38,117.07 rows=1 width=59) (actual time=2,314.773..2,314.960 rows=55 loops=1)

  • Group Key: t.taxpayer_inn
3. 0.396 2,314.766 ↓ 373.0 373 1

Sort (cost=38,117.04..38,117.05 rows=1 width=24) (actual time=2,314.744..2,314.766 rows=373 loops=1)

  • Sort Key: t.taxpayer_inn
  • Sort Method: quicksort Memory: 54kB
4. 0.086 2,314.370 ↓ 373.0 373 1

Nested Loop (cost=18,511.87..38,117.03 rows=1 width=24) (actual time=2,294.090..2,314.370 rows=373 loops=1)

  • Join Filter: (t.foundersid = t3.id)
5. 0.083 0.083 ↑ 1.0 1 1

Seq Scan on "Founders" t3 (cost=0.00..3.17 rows=1 width=16) (actual time=0.012..0.083 rows=1 loops=1)

  • Filter: (code = '182'::text)
  • Rows Removed by Filter: 93
6. 16.895 2,314.201 ↓ 3.4 373 1

Nested Loop (cost=18,511.87..38,112.47 rows=111 width=40) (actual time=2,294.073..2,314.201 rows=373 loops=1)

7. 0.938 0.938 ↓ 6.0 6 1

Seq Scan on dic_bkd t1 (cost=0.00..244.55 rows=1 width=16) (actual time=0.017..0.938 rows=6 loops=1)

  • Filter: (code ~~ '10102%'::text)
  • Rows Removed by Filter: 2678
8. 33.600 2,296.368 ↑ 26.8 62 6

Bitmap Heap Scan on data_ufk t (cost=18,511.87..37,851.31 rows=1,661 width=56) (actual time=382.465..382.728 rows=62 loops=6)

  • Recheck Cond: ((bkdid = t1.id) AND ((taxpayer_inn = ANY ('{2130098350,2420004523,2460201704,2464225590,2466224271,4325003121,4508001178,6601005477,6601006150,6601006262,6601006424,6601007450,6601007682,6601007700,6601007724, (...)
  • Filter: ((date_otch >= '2018-01-01 00:00:00'::timestamp without time zone) AND (date_otch < '2019-01-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 375
  • Heap Blocks: exact=2411
9. 131.148 2,262.768 ↓ 0.0 0 6

BitmapAnd (cost=18,511.87..18,511.87 rows=7,344 width=0) (actual time=377.128..377.128 rows=0 loops=6)

10. 2,064.624 2,064.624 ↓ 17.6 3,710,046 6

Bitmap Index Scan on ix_data_ufk_bkdid (cost=0.00..2,479.48 rows=210,389 width=0) (actual time=344.104..344.104 rows=3,710,046 loops=6)

  • Index Cond: (bkdid = t1.id)
11. 0.008 66.996 ↓ 0.0 0 4

BitmapOr (cost=16,031.72..16,031.72 rows=1,314,623 width=0) (actual time=16.749..16.749 rows=0 loops=4)

12. 21.012 21.012 ↑ 121.2 3,605 4

Bitmap Index Scan on ix_data_ufk_taxpayer_inn (cost=0.00..5,228.55 rows=436,853 width=0) (actual time=5.253..5.253 rows=3,605 loops=4)

  • Index Cond: (taxpayer_inn = ANY ('{2130098350,2420004523,2460201704,2464225590,2466224271,4325003121,4508001178,6601005477,6601006150,6601006262,6601006424,6601007450,6601007682,6601007700,6601007724,660100 (...)
13. 24.048 24.048 ↑ 74.8 5,837 4

Bitmap Index Scan on ix_data_ufk_taxpayer_inn (cost=0.00..5,228.55 rows=436,853 width=0) (actual time=6.012..6.012 rows=5,837 loops=4)

  • Index Cond: (taxpayer_inn = ANY ('{6625013692,6625013702,6625013734,6625013808,6625013822,6625013847,6625013854,6625013893,6625013903,6625013928,6625013935,6625013967,6625013974,6625013981,6625014079,662501 (...)
14. 21.736 21.736 ↑ 112.0 3,901 4

Bitmap Index Scan on ix_data_ufk_taxpayer_inn (cost=0.00..5,228.55 rows=436,853 width=0) (actual time=5.434..5.434 rows=3,901 loops=4)

  • Index Cond: (taxpayer_inn = ANY ('{6662073562,6662082327,6662083049,6662083105,6662087572,6662088368,6662089354,6662090247,6662091681,6662091829,6663019688,6663020595,6663025716,6663038264,6663042006,666304 (...)
15. 0.192 0.192 ↑ 92.4 44 4

Bitmap Index Scan on ix_data_ufk_taxpayer_inn (cost=0.00..48.74 rows=4,064 width=0) (actual time=0.048..0.048 rows=44 loops=4)

  • Index Cond: (taxpayer_inn = ANY ('{6686996111,7451232550,7456015119,9108009615}'::text[]))
Planning time : 31.227 ms
Execution time : 2,315.875 ms