explain.depesz.com

A tool for finding a real cause for slow queries.

Result: kgB

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 2,463.159 13,884.259 ↓ 25,366.1 304,393 1

Sort (cost=27,008.22..27,008.25 rows=12 width=67) (actual time=13,722.868..13,884.259 rows=304,393 loops=1)

  • Sort Key: "_F2".title
  • Sort Method: external merge Disk: 20432kB
2. 249.792 11,421.100 ↓ 25,366.1 304,393 1

Nested Loop Left Join (cost=24,782.39..27,008.00 rows=12 width=67) (actual time=706.393..11,421.100 rows=304,393 loops=1)

3. 216.402 8,127.378 ↓ 25,366.1 304,393 1

Nested Loop (cost=24,782.39..27,002.46 rows=12 width=37) (actual time=706.341..8,127.378 rows=304,393 loops=1)

4. 228.888 4,866.256 ↓ 5,160.5 304,472 1

Nested Loop (cost=24,782.39..26,744.54 rows=59 width=74) (actual time=706.295..4,866.256 rows=304,472 loops=1)

5. 387.036 832.408 ↓ 760.4 317,080 1

HashAggregate (cost=24,782.39..24,786.56 rows=417 width=37) (actual time=706.217..832.408 rows=317,080 loops=1)

6. 445.372 445.372 ↓ 760.4 317,080 1

Seq Scan on ancestors (cost=0.00..24,781.35 rows=417 width=37) (actual time=0.047..445.372 rows=317,080 loops=1)

  • Filter: ('{83119cd4-a94c-4dc6-ba95-4620cfd525c8}'::character varying[] <@ ancestors)
7. 3,804.960 3,804.960 ↑ 1.0 1 317,080

Index Scan using hierarchy_pk on hierarchy (cost=0.00..4.68 rows=1 width=37) (actual time=0.012..0.012 rows=1 loops=317,080)

  • Index Cond: ((hierarchy.id)::text = (ancestors.id)::text)
  • Filter: (((hierarchy.primarytype)::text = ANY ('{Picture,File,Audio,Video}'::text[])) OR ('{Asset}'::character varying[] <@ hierarchy.mixintypes))
8. 3,044.720 3,044.720 ↑ 1.0 1 304,472

Index Scan using misc_pk on misc "_F1" (cost=0.00..4.36 rows=1 width=37) (actual time=0.010..0.010 rows=1 loops=304,472)

  • Index Cond: (("_F1".id)::text = (hierarchy.id)::text)
  • Filter: (("_F1".lifecyclestate)::text <> 'deleted'::text)
9. 3,043.930 3,043.930 ↑ 1.0 1 304,393

Index Scan using dublincore_pk on dublincore "_F2" (cost=0.00..0.45 rows=1 width=67) (actual time=0.010..0.010 rows=1 loops=304,393)

  • Index Cond: ((hierarchy.id)::text = ("_F2".id)::text)