explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qzhm

Settings
# exclusive inclusive rows x rows loops node
1. 4,513.972 5,157.107 ↓ 1.2 127,858 1

GroupAggregate (cost=72,015.61..319,440.28 rows=107,693 width=107) (actual time=549.458..5,157.107 rows=127,858 loops=1)

  • Group Key: clip.id, account.first_name, account.last_name
2. 210.604 643.135 ↓ 1.2 131,406 1

Sort (cost=72,015.61..72,284.85 rows=107,693 width=291) (actual time=549.386..643.135 rows=131,406 loops=1)

  • Sort Key: clip.id, account.first_name, account.last_name
  • Sort Method: external merge Disk: 18720kB
3. 75.354 432.531 ↓ 1.2 131,406 1

Hash Join (cost=41,678.51..48,289.83 rows=107,693 width=291) (actual time=278.622..432.531 rows=131,406 loops=1)

  • Hash Cond: (clip.account_id = account.id)
4. 69.227 356.691 ↓ 1.2 131,406 1

Hash Right Join (cost=41,649.05..46,779.59 rows=107,693 width=296) (actual time=278.128..356.691 rows=131,406 loops=1)

  • Hash Cond: (clip_tag.clip_id = clip.id)
5. 6.437 10.338 ↓ 1.0 11,152 1

Hash Left Join (cost=80.71..868.43 rows=11,146 width=26) (actual time=0.885..10.338 rows=11,152 loops=1)

  • Hash Cond: (clip_tag.tag_id = tag.id)
6. 3.047 3.047 ↓ 1.0 11,152 1

Seq Scan on clip_tag (cost=0.00..634.46 rows=11,146 width=32) (actual time=0.009..3.047 rows=11,152 loops=1)

7. 0.429 0.854 ↑ 1.0 1,270 1

Hash (cost=64.76..64.76 rows=1,276 width=26) (actual time=0.854..0.854 rows=1,270 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 88kB
8. 0.425 0.425 ↑ 1.0 1,270 1

Seq Scan on tag (cost=0.00..64.76 rows=1,276 width=26) (actual time=0.012..0.425 rows=1,270 loops=1)

9. 80.277 277.126 ↓ 1.2 127,858 1

Hash (cost=36,120.18..36,120.18 rows=107,693 width=286) (actual time=277.126..277.126 rows=127,858 loops=1)

  • Buckets: 16384 Batches: 16 Memory Usage: 1454kB
10. 196.849 196.849 ↓ 1.2 127,858 1

Seq Scan on clip (cost=0.00..36,120.18 rows=107,693 width=286) (actual time=0.008..196.849 rows=127,858 loops=1)

  • Filter: (visible AND (NOT inactive) AND (status <> 'created'::text))
  • Rows Removed by Filter: 226715
11. 0.258 0.486 ↑ 1.0 687 1

Hash (cost=20.87..20.87 rows=687 width=27) (actual time=0.486..0.486 rows=687 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
12. 0.228 0.228 ↑ 1.0 687 1

Seq Scan on account (cost=0.00..20.87 rows=687 width=27) (actual time=0.007..0.228 rows=687 loops=1)