explain.depesz.com

PostgreSQL's explain analyze made readable

Result: typ

Settings
# exclusive inclusive rows x rows loops node
1. 57,827.110 73,497.099 ↓ 1.0 2,841,300 1

GroupAggregate (cost=2,378,513.84..8,832,777.20 rows=2,809,255 width=109) (actual time=14,057.172..73,497.099 rows=2,841,300 loops=1)

  • Group Key: clip.id, account.first_name, account.last_name
2. 9,339.443 15,669.989 ↓ 1.5 4,126,323 1

Sort (cost=2,378,513.84..2,385,536.97 rows=2,809,255 width=315) (actual time=14,057.113..15,669.989 rows=4,126,323 loops=1)

  • Sort Key: clip.id, account.first_name, account.last_name
  • Sort Method: external merge Disk: 405168kB
3. 962.788 6,330.546 ↓ 1.5 4,126,323 1

Hash Join (cost=556,406.96..838,964.46 rows=2,809,255 width=315) (actual time=2,758.931..6,330.546 rows=4,126,323 loops=1)

  • Hash Cond: (clip.account_id = account.id)
4. 1,872.728 5,364.967 ↓ 1.5 4,126,323 1

Hash Right Join (cost=556,067.31..799,997.55 rows=2,809,255 width=318) (actual time=2,756.095..5,364.967 rows=4,126,323 loops=1)

  • Hash Cond: (clip_tag.clip_id = clip.id)
5. 587.935 754.317 ↓ 1.0 2,183,790 1

Hash Left Join (cost=1,666.36..71,241.78 rows=2,173,281 width=31) (actual time=14.788..754.317 rows=2,183,790 loops=1)

  • Hash Cond: (clip_tag.tag_id = tag.id)
6. 151.949 151.949 ↓ 1.0 2,183,790 1

Seq Scan on clip_tag (cost=0.00..39,692.81 rows=2,173,281 width=32) (actual time=0.006..151.949 rows=2,183,790 loops=1)

7. 7.972 14.433 ↑ 1.1 34,348 1

Hash (cost=1,191.16..1,191.16 rows=38,016 width=31) (actual time=14.433..14.433 rows=34,348 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2651kB
8. 6.461 6.461 ↑ 1.1 34,348 1

Seq Scan on tag (cost=0.00..1,191.16 rows=38,016 width=31) (actual time=0.006..6.461 rows=34,348 loops=1)

9. 1,023.244 2,737.922 ↓ 1.0 2,841,300 1

Hash (cost=406,805.26..406,805.26 rows=2,809,255 width=303) (actual time=2,737.922..2,737.922 rows=2,841,300 loops=1)

  • Buckets: 16384 Batches: 256 Memory Usage: 1522kB
10. 1,714.678 1,714.678 ↓ 1.0 2,841,300 1

Seq Scan on clip (cost=0.00..406,805.26 rows=2,809,255 width=303) (actual time=0.008..1,714.678 rows=2,841,300 loops=1)

  • Filter: (visible AND (NOT inactive) AND (status <> 'created'::text))
  • Rows Removed by Filter: 452208
11. 1.632 2.791 ↓ 1.0 7,810 1

Hash (cost=244.29..244.29 rows=7,629 width=29) (actual time=2.791..2.791 rows=7,810 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 539kB
12. 1.159 1.159 ↓ 1.0 7,810 1

Seq Scan on account (cost=0.00..244.29 rows=7,629 width=29) (actual time=0.006..1.159 rows=7,810 loops=1)

Planning time : 0.601 ms