explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x6wf

Settings
# exclusive inclusive rows x rows loops node
1. 0.828 9.718 ↓ 10.0 20 1

Unique (cost=92.54..92.57 rows=2 width=103) (actual time=8.536..9.718 rows=20 loops=1)

2. 2.939 8.890 ↓ 1,011.5 2,023 1

Sort (cost=92.54..92.54 rows=2 width=103) (actual time=8.535..8.890 rows=2,023 loops=1)

  • Sort Key: dataset_19.id, dataset_19.jid1, dataset_19.jid2, dataset_19.topic, dataset_19.ttl
  • Sort Method: quicksort Memory: 333kB
3. 1.161 5.951 ↓ 1,011.5 2,023 1

Nested Loop (cost=5.51..92.53 rows=2 width=103) (actual time=0.139..5.951 rows=2,023 loops=1)

  • Join Filter: (lt0_0.from_id = ds2_0._conversation)
4. 0.014 0.470 ↓ 20.0 20 1

Nested Loop (cost=5.08..75.04 rows=1 width=107) (actual time=0.118..0.470 rows=20 loops=1)

5. 0.015 0.156 ↓ 5.0 20 1

Nested Loop (cost=4.65..46.88 rows=4 width=4) (actual time=0.064..0.156 rows=20 loops=1)

6. 0.028 0.028 ↑ 1.0 1 1

Index Scan using index_actors_on_login on actors ds0_0 (cost=0.28..8.30 rows=1 width=4) (actual time=0.026..0.028 rows=1 loops=1)

  • Index Cond: (lower((login)::text) = 'bs58987'::text)
7. 0.090 0.113 ↓ 2.0 20 1

Bitmap Heap Scan on dataset_links_21 lt0_0 (cost=4.37..38.48 rows=10 width=8) (actual time=0.035..0.113 rows=20 loops=1)

  • Recheck Cond: (to_id = ds0_0.id)
  • Heap Blocks: exact=19
8. 0.023 0.023 ↓ 2.0 20 1

Bitmap Index Scan on index_reverse_on_dataset_links_21 (cost=0.00..4.36 rows=10 width=0) (actual time=0.023..0.023 rows=20 loops=1)

  • Index Cond: (to_id = ds0_0.id)
9. 0.300 0.300 ↑ 1.0 1 20

Index Scan using dataset_19_pkey on dataset_19 (cost=0.43..7.03 rows=1 width=103) (actual time=0.014..0.015 rows=1 loops=20)

  • Index Cond: (id = lt0_0.from_id)
  • Filter: ((lower(activity_state) <> ALL ('{expired,closed}'::text[])) OR (lower(activity_state) IS NULL))
10. 4.320 4.320 ↓ 6.3 101 20

Index Scan using index_on_452_on_dataset_45 on dataset_45 ds2_0 (cost=0.43..17.29 rows=16 width=4) (actual time=0.013..0.216 rows=101 loops=20)

  • Index Cond: (_conversation = dataset_19.id)
  • Filter: (id IS NOT NULL)
Planning time : 2.085 ms
Execution time : 9.928 ms