explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Fmw

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 62.930 ↓ 21.0 21 1

Limit (cost=13.26..13.27 rows=1 width=1,931) (actual time=62.924..62.930 rows=21 loops=1)

2. 8.153 62.925 ↓ 21.0 21 1

Sort (cost=13.26..13.27 rows=1 width=1,931) (actual time=62.923..62.925 rows=21 loops=1)

  • Sort Key: state_change_timestamp, id DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 99kB
3. 18.098 54.772 ↓ 11,538.0 11,538 1

Bitmap Heap Scan on controls (cost=12.14..13.25 rows=1 width=1,931) (actual time=37.917..54.772 rows=11,538 loops=1)

  • Recheck Cond: ((control_type_path ~ '*.167025263203122.*'::lquery) AND (resource_path ~ '*.167090142416714.*'::lquery))
  • Heap Blocks: exact=8,664
4. 1.975 36.674 ↓ 0.0 0 1

BitmapAnd (cost=12.14..12.14 rows=1 width=0) (actual time=36.674..36.674 rows=0 loops=1)

5. 26.290 26.290 ↓ 1,073.9 102,022 1

Bitmap Index Scan on controls_control_type_path_idx (cost=0.00..5.39 rows=95 width=0) (actual time=26.290..26.290 rows=102,022 loops=1)

  • Index Cond: (control_type_path ~ '*.167025263203122.*'::lquery)
6. 8.409 8.409 ↓ 121.5 11,538 1

Bitmap Index Scan on controls_resource_path_idx (cost=0.00..6.49 rows=95 width=0) (actual time=8.409..8.409 rows=11,538 loops=1)

  • Index Cond: (resource_path ~ '*.167090142416714.*'::lquery)
Planning time : 0.179 ms
Execution time : 62.975 ms