explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 12xZ

Settings
# exclusive inclusive rows x rows loops node
1. 1,658.473 75,480.935 ↓ 7.5 5,160,552 1

Finalize GroupAggregate (cost=35,311,133.33..35,331,784.70 rows=688,379 width=37) (actual time=70,343.628..75,480.935 rows=5,160,552 loops=1)

  • Group Key: search_term
2. 48,411.489 73,822.462 ↓ 4.9 6,711,107 1

Sort (cost=35,311,133.33..35,314,575.23 rows=1,376,758 width=37) (actual time=70,343.618..73,822.462 rows=6,711,107 loops=1)

  • Sort Key: search_term
  • Sort Method: external merge Disk: 389248kB
3. 1,881.063 25,410.973 ↓ 4.9 6,711,107 1

Gather (cost=35,026,193.69..35,170,753.28 rows=1,376,758 width=37) (actual time=22,637.550..25,410.973 rows=6,711,107 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 9,923.871 23,529.910 ↓ 3.2 2,237,036 3

Partial HashAggregate (cost=35,025,193.69..35,032,077.48 rows=688,379 width=37) (actual time=22,622.849..23,529.910 rows=2,237,036 loops=3)

  • Group Key: search_term
5. 8,281.651 13,606.039 ↑ 1.3 15,559,554 3

Parallel Bitmap Heap Scan on search_query_perf_report (cost=1,319,112.37..34,878,409.95 rows=19,571,165 width=37) (actual time=5,822.464..13,606.039 rows=15,559,554 loops=3)

  • Recheck Cond: (managed_customer_id = 83856)
  • Heap Blocks: exact=469068
6. 5,324.388 5,324.388 ↑ 1.0 46,678,662 1

Bitmap Index Scan on search_query_perf_report_managed_customer_id_campaign_id_da_idx (cost=0.00..1,307,369.67 rows=46,970,796 width=0) (actual time=5,324.388..5,324.388 rows=46,678,662 loops=1)

  • Index Cond: (managed_customer_id = 83856)