explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qcJx : specialRoutingLosses

Settings
# exclusive inclusive rows x rows loops node
1. 0.116 1,068.211 ↓ 121.0 121 1

GroupAggregate (cost=11,170.34..11,170.39 rows=1 width=133) (actual time=1,068.084..1,068.211 rows=121 loops=1)

  • Group Key: lv.mcc_mnc, lv.esme, lv.esme_katalog, lv.smsc, lv.start, lv.finish, lv.esme_alternative
  • Buffers: shared hit=200202
2. 0.118 1,068.095 ↓ 121.0 121 1

Sort (cost=11,170.34..11,170.35 rows=1 width=133) (actual time=1,068.076..1,068.095 rows=121 loops=1)

  • Sort Key: lv.mcc_mnc, lv.esme, lv.esme_katalog, lv.smsc, lv.start, lv.finish, lv.esme_alternative
  • Sort Method: quicksort Memory: 53kB
  • Buffers: shared hit=200202
3. 0.058 1,067.977 ↓ 121.0 121 1

Subquery Scan on lv (cost=11,170.27..11,170.33 rows=1 width=133) (actual time=1,065.430..1,067.977 rows=121 loops=1)

  • Buffers: shared hit=200202
4. 2.249 1,067.919 ↓ 121.0 121 1

GroupAggregate (cost=11,170.27..11,170.32 rows=1 width=133) (actual time=1,065.429..1,067.919 rows=121 loops=1)

  • Group Key: report_mv_routing_esme_per_hour.mcc_mnc, report_mv_routing_esme_per_hour.esme, report_mv_routing_esme_per_hour.esme_katalog, report_mv_routing_esme_per_hour.smsc
  • Buffers: shared hit=200202
5. 3.220 1,065.670 ↓ 1,498.0 1,498 1

Sort (cost=11,170.27..11,170.27 rows=1 width=77) (actual time=1,065.389..1,065.670 rows=1,498 loops=1)

  • Sort Key: report_mv_routing_esme_per_hour.esme, report_mv_routing_esme_per_hour.esme_katalog
  • Sort Method: quicksort Memory: 259kB
  • Buffers: shared hit=200202
6. 1,054.805 1,062.450 ↓ 1,498.0 1,498 1

Bitmap Heap Scan on report_mv_routing_esme_per_hour (cost=46.70..11,170.26 rows=1 width=77) (actual time=9.781..1,062.450 rows=1,498 loops=1)

  • Recheck Cond: ((endtime_num >= 1549404000) AND (endtime_num <= 1642802400))
  • Rows Removed by Index Recheck: 6171504
  • Filter: ((esme_selling_price ~ '^[0-9\.]+$'::text) AND (esme_route_smscroute_price ~ '^[0-9\.]+$'::text) AND (smsc = 'cosmotegr'::text) AND (mcc_mnc = '20201'::text))
  • Rows Removed by Filter: 113200
  • Heap Blocks: lossy=200146
  • Buffers: shared hit=200202
7. 7.645 7.645 ↓ 200.1 2,001,920 1

Bitmap Index Scan on idx_report_mv_routing_esme_per_hour_endtime_num (cost=0.00..46.69 rows=10,006 width=0) (actual time=7.645..7.645 rows=2,001,920 loops=1)

  • Index Cond: ((endtime_num >= 1549404000) AND (endtime_num <= 1642802400))
  • Buffers: shared hit=56