explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XBic

Settings
# exclusive inclusive rows x rows loops node
1. 0.269 23,550.348 ↑ 1.0 1 1

Aggregate (cost=1,276,807.46..1,276,807.46 rows=1 width=8) (actual time=23,550.348..23,550.348 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=247,465, temp read=106,114 written=106,122
  • Functions: 14
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.186 ms, Inlining 10.121 ms, Optimization 277.226 ms, Emission 166.446 ms, Total 456.979 ms
2. 1,823.282 23,550.079 ↑ 612.4 871 1

GroupAggregate (cost=1,256,253.61..1,274,940.71 rows=533,357 width=175) (actual time=19,152.518..23,550.079 rows=871 loops=1)

  • Output: royaltyfiles_drsproviderdatareceived.comp_title, royaltyfiles_drsproviderdatareceived.provider_file_id, royaltyfiles_drsproviderdatareceived.provider_file_name, royaltyfiles_drsproviderdatareceived.music_service, royaltyfiles_drsproviderdatareceived.publisher_name, royaltyfiles_drsproviderdatareceived.provider_work_id, royaltyfiles_drsproviderdatareceived.comp_writers, royaltyfiles_drsproviderdatareceived.share_percent, royaltyfiles_drsproviderdatareceived.territory, royaltyfiles_drsproviderdatareceived.income_type, NULL::double precision
  • Group Key: royaltyfiles_drsproviderdatareceived.comp_title, royaltyfiles_drsproviderdatareceived.provider_file_id, royaltyfiles_drsproviderdatareceived.provider_file_name, royaltyfiles_drsproviderdatareceived.music_service, royaltyfiles_drsproviderdatareceived.publisher_name, royaltyfiles_drsproviderdatareceived.provider_work_id, royaltyfiles_drsproviderdatareceived.comp_writers, royaltyfiles_drsproviderdatareceived.share_percent, royaltyfiles_drsproviderdatareceived.territory, royaltyfiles_drsproviderdatareceived.income_type
  • Filter: (sum(royaltyfiles_drsproviderdatareceived.royalty_dollars) >= '50'::double precision)
  • Rows Removed by Filter: 800,390
  • Buffers: shared hit=247,465, temp read=106,114 written=106,122
3. 19,298.311 21,726.797 ↓ 1.9 4,239,463 1

Sort (cost=1,256,253.61..1,257,344.18 rows=2,181,142 width=175) (actual time=19,124.951..21,726.797 rows=4,239,463 loops=1)

  • Output: royaltyfiles_drsproviderdatareceived.comp_title, royaltyfiles_drsproviderdatareceived.provider_file_id, royaltyfiles_drsproviderdatareceived.provider_file_name, royaltyfiles_drsproviderdatareceived.music_service, royaltyfiles_drsproviderdatareceived.publisher_name, royaltyfiles_drsproviderdatareceived.provider_work_id, royaltyfiles_drsproviderdatareceived.comp_writers, royaltyfiles_drsproviderdatareceived.share_percent, royaltyfiles_drsproviderdatareceived.territory, royaltyfiles_drsproviderdatareceived.income_type, royaltyfiles_drsproviderdatareceived.royalty_dollars
  • Sort Key: royaltyfiles_drsproviderdatareceived.comp_title, royaltyfiles_drsproviderdatareceived.provider_file_id, royaltyfiles_drsproviderdatareceived.provider_file_name, royaltyfiles_drsproviderdatareceived.music_service, royaltyfiles_drsproviderdatareceived.publisher_name, royaltyfiles_drsproviderdatareceived.provider_work_id, royaltyfiles_drsproviderdatareceived.comp_writers, royaltyfiles_drsproviderdatareceived.share_percent, royaltyfiles_drsproviderdatareceived.income_type
  • Sort Method: external merge Disk: 848,912kB
  • Buffers: shared hit=247,465, temp read=106,114 written=106,122
4. 2,428.486 2,428.486 ↓ 1.9 4,239,463 1

Index Scan using royaltyfiles_drsproviderdatareceived_4ea84260 on public.royaltyfiles_drsproviderdatareceived (cost=0.11..1,077,198.56 rows=2,181,142 width=175) (actual time=454.360..2,428.486 rows=4,239,463 loops=1)

  • Output: royaltyfiles_drsproviderdatareceived.comp_title, royaltyfiles_drsproviderdatareceived.provider_file_id, royaltyfiles_drsproviderdatareceived.provider_file_name, royaltyfiles_drsproviderdatareceived.music_service, royaltyfiles_drsproviderdatareceived.publisher_name, royaltyfiles_drsproviderdatareceived.provider_work_id, royaltyfiles_drsproviderdatareceived.comp_writers, royaltyfiles_drsproviderdatareceived.share_percent, royaltyfiles_drsproviderdatareceived.territory, royaltyfiles_drsproviderdatareceived.income_type, royaltyfiles_drsproviderdatareceived.royalty_dollars
  • Index Cond: ((royaltyfiles_drsproviderdatareceived.processing_period_str)::text = '2020-07'::text)
  • Filter: ((NOT royaltyfiles_drsproviderdatareceived.deleted) AND ((royaltyfiles_drsproviderdatareceived.mapping_status IS NULL) OR ((royaltyfiles_drsproviderdatareceived.mapping_status)::text = 'UNMAPPED'::text)) AND ((royaltyfiles_drsproviderdatareceived.territory)::text = 'US'::text))
  • Buffers: shared hit=247,464
Planning time : 0.331 ms
Execution time : 23,678.016 ms