explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n8vg

Settings
# exclusive inclusive rows x rows loops node
1. 42.076 50.545 ↑ 2.7 200 1

GroupAggregate (cost=497.34..618.38 rows=544 width=64) (actual time=8.078..50.545 rows=200 loops=1)

  • Output: count(*), carrier_account_id, country_id, (date_part('isoyear'::text, (filter_date)::timestamp without time zone)), (date_part('month'::text, (filter_date)::timestamp without time zone)), json_agg(json_build_object('filter_date', filter_date, 'phone_calls_duration_in_seconds_incoming', phone_calls_duration_in_seconds_incoming, 'phone_calls_duration_in_seconds_outgoing', phone_calls_duration_in_seconds_outgoing, 'phone_calls_duration_in_minutes_incoming', phone_calls_duration_in_minutes_incoming, 'phone_calls_duration_in_minutes_outgoing', phone_calls_duration_in_minutes_outgoing, 'text_messages_size_incoming', text_messages_size_incoming, 'text_messages_size_outgoing', text_messages_size_outgoing, 'app_usages_total_bytes', app_usages_total_bytes))
  • Group Key: roaming_days.carrier_account_id, roaming_days.country_id, (date_part('isoyear'::text, (roaming_days.filter_date)::timestamp without time zone)), (date_part('month'::text, (roaming_days.filter_date)::timestamp without time zone))
  • Buffers: shared hit=51
2. 4.183 8.469 ↑ 1.0 5,440 1

Sort (cost=497.34..510.94 rows=5,440 width=60) (actual time=7.781..8.469 rows=5,440 loops=1)

  • Output: carrier_account_id, country_id, (date_part('isoyear'::text, (filter_date)::timestamp without time zone)), (date_part('month'::text, (filter_date)::timestamp without time zone)), filter_date, phone_calls_duration_in_seconds_incoming, phone_calls_duration_in_seconds_outgoing, phone_calls_duration_in_minutes_incoming, phone_calls_duration_in_minutes_outgoing, text_messages_size_incoming, text_messages_size_outgoing, app_usages_total_bytes
  • Sort Key: roaming_days.carrier_account_id, roaming_days.country_id, (date_part('isoyear'::text, (roaming_days.filter_date)::timestamp without time zone)), (date_part('month'::text, (roaming_days.filter_date)::timestamp without time zone))
  • Sort Method: quicksort Memory: 958kB
  • Buffers: shared hit=51
3. 4.286 4.286 ↑ 1.0 5,440 1

Seq Scan on public.roaming_days (cost=0.00..159.80 rows=5,440 width=60) (actual time=0.052..4.286 rows=5,440 loops=1)

  • Output: carrier_account_id, country_id, date_part('isoyear'::text, (filter_date)::timestamp without time zone), date_part('month'::text, (filter_date)::timestamp without time zone), filter_date, phone_calls_duration_in_seconds_incoming, phone_calls_duration_in_seconds_outgoing, phone_calls_duration_in_minutes_incoming, phone_calls_duration_in_minutes_outgoing, text_messages_size_incoming, text_messages_size_outgoing, app_usages_total_bytes
  • Buffers: shared hit=51