explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pM9o

Settings
# exclusive inclusive rows x rows loops node
1. 0.696 54.142 ↓ 5,840.0 5,840 1

Nested Loop (cost=6,561.83..71,062.93 rows=1 width=356) (actual time=13.636..54.142 rows=5,840 loops=1)

2. 0.026 0.026 ↑ 1.0 1 1

Index Scan using value_indicator on observable (cost=0.68..2.69 rows=1 width=8) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: ((value = '104.47.44.59'::text) AND (indicator = 'ip'::text))
3. 0.679 53.420 ↓ 324.4 5,840 1

Nested Loop (cost=6,561.16..71,060.05 rows=18 width=364) (actual time=13.608..53.420 rows=5,840 loops=1)

4. 39.429 48.597 ↓ 14.4 259 1

Bitmap Heap Scan on investigation (cost=6,560.60..71,013.30 rows=18 width=356) (actual time=12.180..48.597 rows=259 loops=1)

  • Recheck Cond: (state <> 'closed'::text)
  • Filter: (updated_at > (now() - '03:00:00'::interval))
  • Rows Removed by Filter: 66,732
5. 9.168 9.168 ↓ 1.0 68,163 1

Bitmap Index Scan on index_investigation_on_summarize_ts_and_state_not_closed (cost=0.00..6,560.59 rows=66,835 width=0) (actual time=9.168..9.168 rows=68,163 loops=1)

6. 4.144 4.144 ↓ 23.0 23 259

Index Only Scan using index_observer_observable_on_inv_id_and_observable_id on observer_observable (cost=0.56..2.59 rows=1 width=16) (actual time=0.003..0.016 rows=23 loops=259)

  • Index Cond: ((investigation_id = investigation.id) AND (observable_id = observable.id))
  • Heap Fetches: 5,840
Total runtime : 54.366 ms