explain.depesz.com

A tool for finding a real cause for slow queries.

Result: A8ee

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 4,790.927 14,466.334 ↓ 1.3 1,011,861 1

Sort (cost=444,757.03..446,720.49 rows=785,382 width=56) (actual time=13,495.090..14,466.334 rows=1,011,861 loops=1)

  • Sort Key: "_F2".title
  • Sort Method: external merge Disk: 65360kB
2. 5,500.548 9,675.407 ↓ 1.3 1,011,861 1

Hash Right Join (cost=178,573.13..344,846.21 rows=785,382 width=56) (actual time=3,570.329..9,675.407 rows=1,011,861 loops=1)

  • Hash Cond: (("_F2".id)::text = (hierarchy.id)::text)
3. 604.886 604.886 ↑ 1.0 1,068,530 1

Seq Scan on dublincore "_F2" (cost=0.00..127,656.30 rows=1,068,530 width=55) (actual time=0.020..604.886 rows=1,068,530 loops=1)

4. 401.689 3,569.973 ↓ 1.3 1,011,861 1

Hash (cost=162,619.86..162,619.86 rows=785,382 width=37) (actual time=3,569.973..3,569.973 rows=1,011,861 loops=1)

  • Buckets: 32768 Batches: 4 Memory Usage: 17076kB
5. 1,541.441 3,168.284 ↓ 1.3 1,011,861 1

Hash Join (cost=94,569.78..162,619.86 rows=785,382 width=37) (actual time=1,272.347..3,168.284 rows=1,011,861 loops=1)

  • Hash Cond: (("_F1".id)::text = (hierarchy.id)::text)
6. 354.853 354.853 ↑ 1.0 1,068,530 1

Seq Scan on misc "_F1" (cost=0.00..24,380.62 rows=1,068,530 width=37) (actual time=0.012..354.853 rows=1,068,530 loops=1)

  • Filter: ((lifecyclestate)::text <> 'deleted'::text)
7. 406.396 1,271.990 ↑ 1.2 1,011,861 1

Hash (cost=69,168.03..69,168.03 rows=1,250,540 width=37) (actual time=1,271.990..1,271.990 rows=1,011,861 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 8550kB
8. 865.594 865.594 ↑ 1.2 1,011,861 1

Seq Scan on hierarchy (cost=0.00..69,168.03 rows=1,250,540 width=37) (actual time=0.116..865.594 rows=1,011,861 loops=1)

  • Filter: (((primarytype)::text = ANY ('{Picture,File,Audio,Video,File}'::text[])) OR ('{Asset}'::character varying[] <@ mixintypes))