explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ddb6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.318 ↓ 0.0 0 1

Nested Loop (cost=2,714.02..2,760.54 rows=2 width=12) (actual time=0.318..0.318 rows=0 loops=1)

2.          

Initplan (for Nested Loop)

3. 0.008 0.016 ↑ 1.0 1 1

Aggregate (cost=11.00..11.01 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=1)

4. 0.008 0.008 ↑ 40.0 2 1

Seq Scan on temp_refinesearch_0snnoqftwb3m13g1xjx0qr1b refine_search (cost=0.00..10.80 rows=80 width=4) (actual time=0.008..0.008 rows=2 loops=1)

5. 0.012 0.317 ↓ 0.0 0 1

Nested Loop (cost=2,702.72..2,746.81 rows=2 width=16) (actual time=0.317..0.317 rows=0 loops=1)

6. 0.014 0.165 ↓ 2.0 70 1

Unique (cost=2,702.44..2,702.61 rows=35 width=8) (actual time=0.147..0.165 rows=70 loops=1)

7. 0.022 0.151 ↓ 2.0 70 1

Sort (cost=2,702.44..2,702.53 rows=35 width=8) (actual time=0.146..0.151 rows=70 loops=1)

  • Sort Key: bool.c_documentid
  • Sort Method: quicksort Memory: 28kB
8. 0.007 0.129 ↓ 2.0 70 1

Append (cost=52.16..2,701.54 rows=35 width=8) (actual time=0.082..0.129 rows=70 loops=1)

9. 0.002 0.044 ↓ 0.0 0 1

Bitmap Heap Scan on t_e20so1_document_boolean bool (cost=52.16..2,659.47 rows=1 width=8) (actual time=0.044..0.044 rows=0 loops=1)

  • Recheck Cond: (c_fieldid = ANY ('{b858ee16-ea61-4678-868b-c436f95a0ffa,3aa12f29-24f8-4d43-b1a4-7df8d8adb158}'::uuid[]))
  • Filter: (c_value AND (c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid))
10. 0.042 0.042 ↓ 0.0 0 1

Bitmap Index Scan on t_e20so1_document_boolean_c_fieldid_idx (cost=0.00..52.15 rows=2,441 width=0) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: (c_fieldid = ANY ('{b858ee16-ea61-4678-868b-c436f95a0ffa,3aa12f29-24f8-4d43-b1a4-7df8d8adb158}'::uuid[]))
11. 0.078 0.078 ↓ 2.1 70 1

Index Scan using uc_unique_t_e20so1_document_boolean_folders on t_e20so1_document_boolean_folders bool_1 (cost=0.42..41.90 rows=34 width=8) (actual time=0.036..0.078 rows=70 loops=1)

  • Index Cond: (c_fieldid = ANY ('{b858ee16-ea61-4678-868b-c436f95a0ffa,3aa12f29-24f8-4d43-b1a4-7df8d8adb158}'::uuid[]))
  • Filter: (c_value AND (c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid))
12. 0.140 0.140 ↓ 0.0 0 70

Index Only Scan using tempdilldown_pkid_level on tempdilldown temp_drilldown_0snnoqftwb3m13g1xjx0qr1b (cost=0.28..1.24 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=70)

  • Index Cond: (("_PKID" = bool.c_documentid) AND (c_level = $0))
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Append (cost=0.29..1.35 rows=1 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using t_e20so1_document_datastore_11_pkey on t_e20so1_document_datastore_11 document (cost=0.29..1.34 rows=1 width=8) (never executed)

  • Index Cond: ((c_documentid = bool.c_documentid) AND (c_datastoresid = 11))
  • Heap Fetches: 0
Planning time : 1.915 ms