explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Up2v

Settings
# exclusive inclusive rows x rows loops node
1. 0.082 31.360 ↓ 0.0 0 1

Bitmap Heap Scan on public.subscribers (cost=432.47..494.79 rows=1 width=654) (actual time=31.360..31.360 rows=0 loops=1)

  • Output: subscriberid, msisdn, imsi, iccid, imei, status, email, name, recharges, last_bundle, last_bundle_web, last_tariff, last_tariff_web, tariff_renewal, recharges2, recharges3, CASE WHEN (((last_tariff).tariff_code = ANY (('{101115,101102,101101}'::text[])::integer[])) AND ((last_tariff).tariff_time >= (to_timestamp('2019-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone) AND ((last_tariff).tariff_time <= (to_timestamp('2119-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone)) THEN '0'::text ELSE NULL::text END, CASE WHEN (((tariff_renewal).tariff_code = ANY (('{101115,101102,101101}'::text[])::integer[])) AND ((tariff_renewal).tariff_time >= (to_timestamp('2019-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone) AND ((tariff_renewal).tariff_time <= (to_timestamp('2119-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone)) THEN '0'::text ELSE NULL::text END
  • Recheck Cond: (((subscribers.msisdn)::text = ANY ((get_file_values_array2('5617;5623;5640;5696;5728;5748;5771;5795;5806;5810;5814;5824;5836;5843;5872'::character varying))::text[])) OR ((subscribers.msisdn)::text = '573195598463'::text) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5923'::character varying))::text[])) OR ((subscribers.msisdn)::text = '573015787865'::text) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5936'::character varying))::text[])) OR ((subscribers.msisdn)::text = '573003121701'::text) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5973;6026;6120;6203'::character varying))::text[])) OR ((subscribers.imsi)::text = ANY ((get_file_values_array2('6214'::character varying))::text[])) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('6222'::character varying))::text[])) OR ((subscribers.imsi)::text = ANY ((get_file_values_array2('6271;6330;6403'::character varying))::text[])) OR ((subscribers.imsi)::text = '732123907050512'::text) OR (((subscribers.imsi)::text = '732123904434796'::text) AND ((subscribers.imsi)::text = '732123909169553'::text) AND ((subscribers.imsi)::text = '732123909984179'::text)) OR (((subscribers.imsi)::text = '732123908653879'::text) AND ((subscribers.imsi)::text = '732123906861085'::text) AND ((subscribers.imsi)::text = '732123906194441'::text)) OR (((subscribers.imsi)::text = '732123908561013'::text) AND ((subscribers.imsi)::text = '732123904476474'::text) AND ((subscribers.imsi)::text = '732123909332071'::text)) OR (((subscribers.imsi)::text = '732123909488715'::text) AND ((subscribers.imsi)::text = '732123906826237'::text) AND ((subscribers.imsi)::text = '732123908996668'::text) AND ((subscribers.imsi)::text = '732123906475238'::text)) OR (((subscribers.imsi)::text = '732123905924523'::text) AND ((subscribers.imsi)::text = '732123901489812'::text)) OR ((subscribers.imsi)::text = '732123908996668'::text) OR ((subscribers.imsi)::text = '732123909064723'::text) OR (((subscribers.imsi)::text = '732123900364975'::text) AND ((subscribers.imsi)::text = '732123908108948'::text)) OR ((subscribers.imsi)::text = '732123908560695'::text) OR ((subscribers.imsi)::text = '732123909417532'::text) OR (((subscribers.imsi)::text = '732123909151026'::text) AND ((subscribers.imsi)::text = '732123907743831'::text)) OR ((subscribers.imsi)::text = '732123906192202'::text) OR ((subscribers.imsi)::text = ' 732123908319983'::text) OR ((subscribers.imsi)::text = ANY ((get_file_values_array2('6739;6745;6766'::character varying))::text[])))
  • Filter: ((((NOT (subscribers.last_tariff IS NULL)) AND ((subscribers.last_tariff).tariff_code = ANY (('{101115,101102,101101}'::text[])::integer[])) AND ((subscribers.last_tariff).tariff_time >= (to_timestamp('2019-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone) AND ((subscribers.last_tariff).tariff_time <= (to_timestamp('2119-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone)) OR ((NOT (subscribers.tariff_renewal IS NULL)) AND ((subscribers.tariff_renewal).tariff_code = ANY (('{101115,101102,101101}'::text[])::integer[])) AND ((subscribers.tariff_renewal).tariff_time >= (to_timestamp('2019-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone) AND ((subscribers.tariff_renewal).tariff_time <= (to_timestamp('2119-07-17 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text))::timestamp without time zone))) AND (((subscribers.msisdn)::text = ANY ((get_file_values_array2('5617;5623;5640;5696;5728;5748;5771;5795;5806;5810;5814;5824;5836;5843;5872'::character varying))::text[])) OR ((subscribers.msisdn)::text = '573195598463'::text) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5923'::character varying))::text[])) OR ((subscribers.msisdn)::text = '573015787865'::text) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5936'::character varying))::text[])) OR ((subscribers.msisdn)::text = '573003121701'::text) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5973;6026;6120;6203'::character varying))::text[])) OR ((subscribers.imsi)::text = ANY ((get_file_values_array2('6214'::character varying))::text[])) OR ((subscribers.msisdn)::text = ANY ((get_file_values_array2('6222'::character varying))::text[])) OR ((subscribers.imsi)::text = ANY ((get_file_values_array2('6271;6330;6403'::character varying))::text[])) OR ((subscribers.imsi)::text = '732123907050512'::text) OR (((subscribers.imsi)::text = '732123904434796'::text) AND ((subscribers.imsi)::text = '732123909169553'::text) AND ((subscribers.imsi)::text = '732123909984179'::text)) OR (((subscribers.imsi)::text = '732123908653879'::text) AND ((subscribers.imsi)::text = '732123906861085'::text) AND ((subscribers.imsi)::text = '732123906194441'::text)) OR (((subscribers.imsi)::text = '732123908561013'::text) AND ((subscribers.imsi)::text = '732123904476474'::text) AND ((subscribers.imsi)::text = '732123909332071'::text)) OR (((subscribers.imsi)::text = '732123909488715'::text) AND ((subscribers.imsi)::text = '732123906826237'::text) AND ((subscribers.imsi)::text = '732123908996668'::text) AND ((subscribers.imsi)::text = '732123906475238'::text)) OR (((subscribers.imsi)::text = '732123905924523'::text) AND ((subscribers.imei)::text = '732123901167972'::text) AND ((subscribers.imsi)::text = '732123901489812'::text)) OR ((subscribers.imsi)::text = '732123908996668'::text) OR ((subscribers.imsi)::text = '732123909064723'::text) OR (((subscribers.imsi)::text = '732123900364975'::text) AND ((subscribers.imsi)::text = '732123908108948'::text)) OR ((subscribers.imsi)::text = '732123908560695'::text) OR ((subscribers.imsi)::text = '732123909417532'::text) OR (((subscribers.imsi)::text = '732123909151026'::text) AND ((subscribers.imsi)::text = '732123907743831'::text)) OR ((subscribers.imsi)::text = '732123906192202'::text) OR ((subscribers.imsi)::text = ' 732123908319983'::text) OR ((subscribers.imsi)::text = ANY ((get_file_values_array2('6739;6745;6766'::character varying))::text[]))))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=3
2. 0.010 31.278 ↓ 0.0 0 1

BitmapOr (cost=432.47..432.47 rows=10 width=0) (actual time=31.278..31.278 rows=0 loops=1)

3. 0.430 0.430 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.430..0.430 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5617;5623;5640;5696;5728;5748;5771;5795;5806;5810;5814;5824;5836;5843;5872'::character varying))::text[]))
4. 0.036 0.036 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = '573195598463'::text)
5. 0.260 0.260 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.260..0.260 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5923'::character varying))::text[]))
6. 0.023 0.023 ↑ 1.0 1 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = '573015787865'::text)
7. 0.251 0.251 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.251..0.251 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5936'::character varying))::text[]))
8. 0.024 0.024 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = '573003121701'::text)
9. 0.254 0.254 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.254..0.254 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = ANY ((get_file_values_array2('5973;6026;6120;6203'::character varying))::text[]))
10. 0.241 0.241 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.241..0.241 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = ANY ((get_file_values_array2('6214'::character varying))::text[]))
11. 0.247 0.247 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_msisdn_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.247..0.247 rows=0 loops=1)

  • Index Cond: ((subscribers.msisdn)::text = ANY ((get_file_values_array2('6222'::character varying))::text[]))
12. 0.243 0.243 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.243..0.243 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = ANY ((get_file_values_array2('6271;6330;6403'::character varying))::text[]))
13. 0.042 0.042 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = '732123907050512'::text)
14. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123904434796'::text) AND ((subscribers.imsi)::text = '732123909169553'::text) AND ((subscribers.imsi)::text = '732123909984179'::text))
15. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123908653879'::text) AND ((subscribers.imsi)::text = '732123906861085'::text) AND ((subscribers.imsi)::text = '732123906194441'::text))
16. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123908561013'::text) AND ((subscribers.imsi)::text = '732123904476474'::text) AND ((subscribers.imsi)::text = '732123909332071'::text))
17. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123909488715'::text) AND ((subscribers.imsi)::text = '732123906826237'::text) AND ((subscribers.imsi)::text = '732123908996668'::text) AND ((subscribers.imsi)::text = '732123906475238'::text))
18. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123905924523'::text) AND ((subscribers.imsi)::text = '732123901489812'::text))
19. 0.027 0.027 ↑ 1.0 1 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((subscribers.imsi)::text = '732123908996668'::text)
20. 0.043 0.043 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = '732123909064723'::text)
21. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123900364975'::text) AND ((subscribers.imsi)::text = '732123908108948'::text))
22. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = '732123908560695'::text)
23. 0.027 0.027 ↑ 1.0 1 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: ((subscribers.imsi)::text = '732123909417532'::text)
24. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (((subscribers.imsi)::text = '732123909151026'::text) AND ((subscribers.imsi)::text = '732123907743831'::text))
25. 28.606 28.606 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=28.606..28.606 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = '732123906192202'::text)
26. 0.045 0.045 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.045..0.045 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = ' 732123908319983'::text)
27. 0.439 0.439 ↓ 0.0 0 1

Bitmap Index Scan on subscribers_temp_imsi_idx (cost=0.00..44.62 rows=1 width=0) (actual time=0.439..0.439 rows=0 loops=1)

  • Index Cond: ((subscribers.imsi)::text = ANY ((get_file_values_array2('6739;6745;6766'::character varying))::text[]))
Planning time : 21,089.024 ms
Execution time : 31.772 ms