explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MrAW

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

Nested Loop (cost=2,713.74..2,783.29 rows=3 width=12) (actual time=1.181..1.181 rows=0 loops=1)

2.          

Initplan (for Nested Loop)

3. 0.006 0.012 ↑ 1.0 1 1

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

4. 0.006 0.006 ↑ 40.0 2 1

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

5. 0.000 1.181 ↓ 0.0 0 1

Nested Loop (cost=2,702.44..2,768.20 rows=3 width=16) (actual time=1.180..1.181 rows=0 loops=1)

  • Join Filter: (bool.c_documentid = temp_drilldown_0snnoqftwb3m13g1xjx0qr1b."_PKID")
6. 0.015 0.839 ↓ 2.0 70 1

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

7. 0.041 0.824 ↓ 2.0 70 1

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

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

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

9. 0.004 0.671 ↓ 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.671..0.671 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.667 0.667 ↓ 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.667..0.667 rows=0 loops=1)

  • Index Cond: (c_fieldid = ANY ('{b858ee16-ea61-4678-868b-c436f95a0ffa,3aa12f29-24f8-4d43-b1a4-7df8d8adb158}'::uuid[]))
11. 0.104 0.104 ↓ 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.061..0.104 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.024 0.350 ↓ 0.0 0 70

Materialize (cost=0.00..56.88 rows=16 width=8) (actual time=0.005..0.005 rows=0 loops=70)

13. 0.326 0.326 ↓ 0.0 0 1

Seq Scan on tempdilldown temp_drilldown_0snnoqftwb3m13g1xjx0qr1b (cost=0.00..56.80 rows=16 width=8) (actual time=0.326..0.326 rows=0 loops=1)

  • Filter: (c_level = $0)
  • Rows Removed by Filter: 2891
14. 0.000 0.000 ↓ 0.0 0

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

15. 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.636 ms