explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 13CV

Settings
# exclusive inclusive rows x rows loops node
1. 1.287 72.157 ↓ 3.0 3 1

HashAggregate (cost=73,632.33..73,632.34 rows=1 width=357) (actual time=72.155..72.157 rows=3 loops=1)

2. 0.893 70.870 ↓ 5,840.0 5,840 1

Nested Loop (cost=6,576.01..73,632.33 rows=1 width=357) (actual time=16.013..70.870 rows=5,840 loops=1)

3. 0.033 0.033 ↑ 1.0 1 1

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

  • Index Cond: ((value = '104.47.44.59'::text) AND (indicator = 'ip'::text))
4. 1.204 69.944 ↓ 648.9 5,840 1

Nested Loop (cost=6,575.33..73,629.55 rows=9 width=365) (actual time=15.979..69.944 rows=5,840 loops=1)

5. 52.818 63.674 ↓ 33.1 298 1

Bitmap Heap Scan on investigation (cost=6,574.77..73,606.17 rows=9 width=357) (actual time=14.276..63.674 rows=298 loops=1)

  • Recheck Cond: (state <> 'closed'::text)
  • Filter: (updated_at > (now() - '03:00:00'::interval))
  • Rows Removed by Filter: 66725
6. 10.856 10.856 ↑ 1.0 67,843 1

Bitmap Index Scan on index_investigation_on_summarize_ts_and_state_not_closed (cost=0.00..6,574.77 rows=69,670 width=0) (actual time=10.856..10.856 rows=67,843 loops=1)

7. 5.066 5.066 ↓ 20.0 20 298

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.004..0.017 rows=20 loops=298)

  • Index Cond: ((investigation_id = investigation.id) AND (observable_id = observable.id))
  • Heap Fetches: 5840
Total runtime : 72.228 ms