explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iSdW

Settings
# exclusive inclusive rows x rows loops node
1. 57,076.479 72,284.689 ↓ 1.0 2,848,551 1

GroupAggregate (cost=2,354,482.30..8,629,497.01 rows=2,731,236 width=109) (actual time=13,934.251..72,284.689 rows=2,848,551 loops=1)

  • Group Key: clip.id, account.first_name, account.last_name
2. 8,926.250 15,208.210 ↓ 1.5 4,133,643 1

Sort (cost=2,354,482.30..2,361,310.39 rows=2,731,236 width=317) (actual time=13,674.616..15,208.210 rows=4,133,643 loops=1)

  • Sort Key: clip.id, account.first_name, account.last_name
  • Sort Method: external merge Disk: 407056kB
3. 952.171 6,281.960 ↓ 1.5 4,133,643 1

Hash Join (cost=577,106.12..858,242.34 rows=2,731,236 width=317) (actual time=2,740.153..6,281.960 rows=4,133,643 loops=1)

  • Hash Cond: (clip.account_id = account.id)
4. 1,861.870 5,326.199 ↓ 1.5 4,133,643 1

Hash Right Join (cost=576,766.47..820,348.19 rows=2,731,236 width=320) (actual time=2,736.513..5,326.199 rows=4,133,643 loops=1)

  • Hash Cond: (clip_tag.clip_id = clip.id)
5. 585.559 743.885 ↓ 1.0 2,183,893 1

Hash Left Join (cost=1,666.36..71,241.78 rows=2,173,281 width=31) (actual time=12.655..743.885 rows=2,183,893 loops=1)

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

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

7. 6.915 12.371 ↑ 1.1 34,351 1

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

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

Seq Scan on tag (cost=0.00..1,191.16 rows=38,016 width=31) (actual time=0.004..5.456 rows=34,351 loops=1)

9. 975.691 2,720.444 ↓ 1.0 2,848,551 1

Hash (cost=428,935.66..428,935.66 rows=2,731,236 width=305) (actual time=2,720.444..2,720.444 rows=2,848,551 loops=1)

  • Buckets: 16384 Batches: 256 Memory Usage: 1528kB
10. 1,744.753 1,744.753 ↓ 1.0 2,848,551 1

Seq Scan on clip (cost=0.00..428,935.66 rows=2,731,236 width=305) (actual time=0.008..1,744.753 rows=2,848,551 loops=1)

  • Filter: (visible AND (NOT inactive) AND (status <> 'created'::text))
  • Rows Removed by Filter: 452638
11. 2.073 3.590 ↓ 1.0 7,871 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 543kB
12. 1.517 1.517 ↓ 1.0 7,871 1

Seq Scan on account (cost=0.00..244.29 rows=7,629 width=29) (actual time=0.005..1.517 rows=7,871 loops=1)

Planning time : 1.358 ms