explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G7kf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 695.654 ↑ 1.0 5 1

Limit (cost=207,196.85..207,196.86 rows=5 width=20) (actual time=695.653..695.654 rows=5 loops=1)

2. 0.036 695.653 ↑ 19.8 5 1

Sort (cost=207,196.85..207,197.10 rows=99 width=20) (actual time=695.652..695.653 rows=5 loops=1)

  • Sort Key: (count(DISTINCT mi.checksum_sid)) DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 6.638 695.617 ↑ 1.0 99 1

GroupAggregate (cost=205,847.87..207,195.20 rows=99 width=20) (actual time=686.796..695.617 rows=99 loops=1)

  • Group Key: fact.account_sid, fact.activity_type
4. 8.905 688.979 ↑ 5.1 26,438 1

Sort (cost=205,847.87..206,184.46 rows=134,634 width=16) (actual time=686.757..688.979 rows=26,438 loops=1)

  • Sort Key: fact.account_sid, fact.activity_type
  • Sort Method: quicksort Memory: 2008kB
5. 49.904 680.074 ↑ 5.1 26,438 1

Hash Join (cost=12,713.93..192,074.94 rows=134,634 width=16) (actual time=114.918..680.074 rows=26,438 loops=1)

  • Hash Cond: (mi.checksum_sid = fact.checksum_sid)
6. 522.053 547.610 ↑ 1.0 106,097 1

Bitmap Heap Scan on meeting_inheritance mi (cost=3,629.59..175,889.33 rows=109,361 width=4) (actual time=30.952..547.610 rows=106,097 loops=1)

  • Recheck Cond: ((activity_date > 1544316837) AND (activity_date < 1549673664))
  • Rows Removed by Index Recheck: 2499276
  • Filter: ((NOT is_internal) AND (NOT is_blacklist) AND (NOT is_partner))
  • Rows Removed by Filter: 202609
  • Heap Blocks: exact=28691 lossy=53298
7. 25.557 25.557 ↑ 1.0 106,097 1

Bitmap Index Scan on combineddatemi (cost=0.00..3,602.25 rows=109,361 width=0) (actual time=25.557..25.557 rows=106,097 loops=1)

  • Index Cond: ((is_blacklist = false) AND (is_partner = false) AND (is_internal = false) AND (activity_date > 1544316837) AND (activity_date < 1549673664))
8. 45.948 82.560 ↑ 1.0 247,304 1

Hash (cost=4,785.04..4,785.04 rows=247,304 width=16) (actual time=82.560..82.560 rows=247,304 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3935kB
9. 36.612 36.612 ↑ 1.0 247,304 1

Seq Scan on derived_activity_account_meeting_fact fact (cost=0.00..4,785.04 rows=247,304 width=16) (actual time=0.142..36.612 rows=247,304 loops=1)