explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EzYP

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 21,639.452 ↑ 1.0 5 1

Limit (cost=456,245.07..456,245.08 rows=5 width=18) (actual time=21,639.363..21,639.452 rows=5 loops=1)

  • loops=1)
2. 0.492 21,639.366 ↑ 60.0 5 1

Sort (cost=456,245.07..456,245.82 rows=300 width=18) (actual time=21,639.346..21,639.366 rows=5 loops=1)

  • Sort Key: (count(DISTINCT mi.checksum_sid))
  • Sort Method: top-N heapsort Memory: 25kB
3. 951.315 21,638.874 ↑ 3.0 100 1

GroupAggregate (cost=449,481.98..456,240.09 rows=300 width=18) (actual time=19,789.339..21,638.874 rows=100 loops=1)

  • Group Key: fact.account_sid, fact.activity_type
4. 1,933.922 20,687.559 ↑ 2.2 309,257 1

Sort (cost=449,481.98..451,170.75 rows=675,511 width=14) (actual time=19,785.675..20,687.559 rows=309,257 loops=1)

  • Sort Key: fact.account_sid, fact.activity_type
  • Sort Method: external merge Disk: 7832kB
5. 5,490.590 18,753.637 ↑ 2.2 309,257 1

Hash Join (cost=18,416.32..372,527.03 rows=675,511 width=14) (actual time=3,382.548..18,753.637 rows=309,257 loops=1)

  • Hash Cond: (mi.checksum_sid = fact.checksum_sid)
6. 9,887.258 9,887.258 ↓ 1.0 1,252,026 1

Seq Scan on meeting_inheritance mi (cost=0.00..281,819.00 rows=1,223,488 width=4) (actual time=1.575..9,887.258 rows=1,252,026 loops=1)

  • Filter: ((NOT is_internal) AND (NOT is_blacklist) AND (NOT is_partner))
  • Rows Removed by Filter: 8747974
7. 3,375.789 3,375.789 ↑ 1.0 501,392 1

Hash (cost=9,699.92..9,699.92 rows=501,392 width=14) (actual time=3,375.783..3,375.789 rows=501,392 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3976kB
  • -> Seq Scan on derived_activity_account_fact fact (cost=0.00..9699.92 rows=501392 width=14) (actual time=0.596..1780.428 rows=501392