explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wysA

Settings
# exclusive inclusive rows x rows loops node
1. 0.091 152,024.311 ↓ 1.1 67 1

Sort (cost=2,317,262.35..2,317,262.50 rows=61 width=27) (actual time=152,024.305..152,024.311 rows=67 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared read=318147 dirtied=274 written=23, temp read=7116 written=7144
2. 1,507.970 152,024.220 ↓ 1.1 67 1

GroupAggregate (cost=2,308,960.50..2,317,260.54 rows=61 width=27) (actual time=150,381.755..152,024.220 rows=67 loops=1)

  • Group Key: browsername
  • Buffers: shared read=318147 dirtied=274 written=23, temp read=7116 written=7144
3. 577.204 150,516.250 ↑ 1.5 560,135 1

Sort (cost=2,308,960.50..2,311,035.36 rows=829,943 width=43) (actual time=150,380.802..150,516.250 rows=560,135 loops=1)

  • Sort Key: browsername
  • Sort Method: external merge Disk: 30952kB
  • Buffers: shared read=318147 dirtied=274 written=23, temp read=5048 written=5067
4. 0.000 149,939.046 ↑ 1.5 560,135 1

Gather (cost=46,126.34..2,201,833.59 rows=829,943 width=43) (actual time=212.707..149,939.046 rows=560,135 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared read=318147 dirtied=274 written=23
5. 149,804.966 150,001.786 ↑ 1.9 186,712 3

Parallel Bitmap Heap Scan on stats (cost=45,126.34..2,117,839.29 rows=345,810 width=43) (actual time=207.436..150,001.786 rows=186,712 loops=3)

  • Recheck Cond: ((company= 13549) AND (createdate > '2018-01-01 00:00:00+01'::timestamp with time zone) AND (createdate < '2019-01-01 00:00:00+01'::timestamp with time zone))
  • Rows Removed by Index Recheck: 1394978
  • Heap Blocks: exact=12976 lossy=78595
  • Buffers: shared read=318147 dirtied=274 written=23
6. 196.820 196.820 ↑ 1.5 560,135 1

Bitmap Index Scan on stats_new_company_createdate_index_1 (cost=0.00..44,918.85 rows=829,943 width=0) (actual time=196.820..196.820 rows=560,135 loops=1)

  • Index Cond: ((company= 13549) AND (createdate > '2018-01-01 00:00:00+01'::timestamp with time zone) AND (createdate < '2019-01-01 00:00:00+01'::timestamp with time zone))
  • Buffers: shared read=5888 written=1
Planning time : 0.333 ms