explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Yso

Settings
# exclusive inclusive rows x rows loops node
1. 439,783.761 5,706,980.461 ↑ 3,032.0 28,549 1

GroupAggregate (cost=157,342,649.00..172,354,824.57 rows=86,559,343 width=231) (actual time=4,686,290.856..5,706,980.461 rows=28,549 loops=1)

  • Group Key: country_iso, state, county, locality, tax_type, tax_level, rate
2. 1,519,097.874 5,267,196.700 ↑ 1.1 231,125,931 1

Sort (cost=157,342,649.00..157,964,772.35 rows=248,849,340 width=68) (actual time=4,686,248.077..5,267,196.700 rows=231,125,931 loops=1)

  • Sort Key: country_iso, state, county, locality, tax_type, tax_level, rate
  • Sort Method: external merge Disk: 20012160kB
3. 3,748,098.826 3,748,098.826 ↑ 1.1 231,125,931 1

Index Scan using transactions_part_for_plat_id_262_committed_date_clustered__idx on transactions_part_for_plat_id_262 (cost=0.57..102,226,312.90 rows=248,849,340 width=68) (actual time=7.593..3,748,098.826 rows=231,125,931 loops=1)

  • Index Cond: ((committed_date >= '2019-10-01 00:00:00'::timestamp without time zone) AND (committed_date < '2020-01-01 00:00:00'::timestamp without time zone))
  • Filter: (is_committed AND (NOT is_no_tax_transaction) AND (tax_data_id <> 0))
  • Rows Removed by Filter: 25185489
Planning time : 102.439 ms
Execution time : 5,707,791.460 ms