explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mQn3

Settings
# exclusive inclusive rows x rows loops node
1. 13.957 958.881 ↓ 324.4 16,546 1

Nested Loop (cost=1.83..245,385.89 rows=51 width=356) (actual time=3.344..958.881 rows=16,546 loops=1)

2. 2.023 911.832 ↓ 324.4 16,546 1

Nested Loop (cost=1.41..245,362.17 rows=51 width=8) (actual time=3.308..911.832 rows=16,546 loops=1)

3. 0.002 0.081 ↑ 1.0 1 1

Nested Loop (cost=0.85..4.90 rows=1 width=16) (actual time=0.078..0.081 rows=1 loops=1)

4. 0.047 0.047 ↑ 1.0 1 1

Index Scan using scan_result_pkey on scan_result (cost=0.42..2.44 rows=1 width=8) (actual time=0.046..0.047 rows=1 loops=1)

  • Index Cond: (id = 2736361)
5. 0.032 0.032 ↑ 1.0 1 1

Index Only Scan using observable_pkey on observable (cost=0.42..2.45 rows=1 width=8) (actual time=0.030..0.032 rows=1 loops=1)

  • Index Cond: (id = scan_result.observable_id)
  • Heap Fetches: 0
6. 909.728 909.728 ↓ 3.6 16,546 1

Index Only Scan using index_observer_observable_on_inv_id_and_observable_id on observer_observable (cost=0.56..245,311.08 rows=4,619 width=16) (actual time=3.229..909.728 rows=16,546 loops=1)

  • Index Cond: (observable_id = observable.id)
  • Heap Fetches: 16546
7. 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 : 959.630 ms