explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DyBn

Settings
# exclusive inclusive rows x rows loops node
1. 0.112 17,027.949 ↑ 1.0 5 1

Limit (cost=456,246.11..456,246.12 rows=5 width=18) (actual time=17,027.873..17,027.949 rows=5 loops=1)

  • loops=1)
2. 0.518 17,027.837 ↑ 60.0 5 1

Sort (cost=456,246.11..456,246.86 rows=300 width=18) (actual time=17,027.824..17,027.837 rows=5 loops=1)

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

GroupAggregate (cost=449,482.99..456,241.13 rows=300 width=18) (actual time=15,176.169..17,027.319 rows=100 loops=1)

  • Group Key: fact.account_sid, fact.activity_type
4. 1,889.283 16,073.603 ↑ 2.2 309,257 1

Sort (cost=449,482.99..451,171.77 rows=675,514 width=14) (actual time=15,172.517..16,073.603 rows=309,257 loops=1)

  • Sort Key: fact.account_sid, fact.activity_type
  • Sort Method: external merge Disk: 7832kB
5. 5,014.994 14,184.320 ↑ 2.2 309,257 1

Hash Join (cost=18,416.32..372,527.73 rows=675,514 width=14) (actual time=3,263.718..14,184.320 rows=309,257 loops=1)

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

Seq Scan on meeting_inheritance mi (cost=0.00..281,819.45 rows=1,223,493 width=4) (actual time=1.438..5,909.996 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,259.330 3,259.330 ↑ 1.0 501,392 1

Hash (cost=9,699.92..9,699.92 rows=501,392 width=14) (actual time=3,259.325..3,259.330 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.179..1702.382 rows=501392