explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bMVH

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 2,438.197 ↓ 55.0 55 1

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

2. 0.180 2,438.190 ↓ 55.0 55 1

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

  • Group Key: t.taxpayer_inn
3. 0.462 2,438.010 ↓ 373.0 373 1

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

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

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

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

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

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

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

7. 1.079 1.079 ↓ 6.0 6 1

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

  • Filter: (code ~~ '10102%'::text)
  • Rows Removed by Filter: 2678
8. 37.962 2,418.354 ↑ 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=402.771..403.059 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. 132.470 2,380.392 ↓ 0.0 0 6

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

10. 2,182.134 2,182.134 ↓ 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=363.689..363.689 rows=3,710,046 loops=6)

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

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

12. 20.676 20.676 ↑ 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.169..5.169 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. 23.544 23.544 ↑ 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=5.886..5.886 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.320 21.320 ↑ 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.330..5.330 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.240 0.240 ↑ 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.060..0.060 rows=44 loops=4)

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