explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z9B6

Settings
# exclusive inclusive rows x rows loops node
1. 4.222 738.897 ↓ 324.4 16,546 1

Nested Loop (cost=1.66..413,435.31 rows=51 width=356) (actual time=1.883..738.897 rows=16,546 loops=1)

2. 1.612 701.583 ↓ 324.4 16,546 1

Nested Loop (cost=1.24..413,411.59 rows=51 width=8) (actual time=1.865..701.583 rows=16,546 loops=1)

3. 0.045 0.045 ↑ 1.0 1 1

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

  • Index Cond: ((value = '104.47.44.59'::text) AND (indicator = 'ip'::text))
4. 699.926 699.926 ↓ 3.6 16,546 1

Index Only Scan using index_observer_observable_on_inv_id_and_observable_id on observer_observable (cost=0.56..413,362.71 rows=4,619 width=16) (actual time=1.818..699.926 rows=16,546 loops=1)

  • Index Cond: (observable_id = observable.id)
  • Heap Fetches: 16546
5. 33.092 33.092 ↑ 1.0 1 16,546

Index Scan using incident_pkey on investigation (cost=0.42..0.46 rows=1 width=356) (actual time=0.002..0.002 rows=1 loops=16,546)

  • Index Cond: (id = observer_observable.investigation_id)
Total runtime : 739.526 ms