explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9HbZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 5.599 ↓ 0.0 0 1

Limit (cost=211,578.30..211,578.54 rows=1 width=2,458) (actual time=5.599..5.599 rows=0 loops=1)

2. 0.000 5.598 ↓ 0.0 0 1

Unique (cost=211,578.30..211,578.54 rows=1 width=2,458) (actual time=5.598..5.598 rows=0 loops=1)

3. 0.147 5.598 ↓ 0.0 0 1

Sort (cost=211,578.30..211,578.30 rows=1 width=2,458) (actual time=5.598..5.598 rows=0 loops=1)

  • Sort Key: dataset_1.created_at, dataset_1.updated_at, dataset_1.concrete_id, dataset_1.type, dataset_1.activity_state, dataset_1.alert_summary, dataset_1.al
  • Sort Method: quicksort Memory: 25kB
4. 0.006 5.451 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.30..211,578.29 rows=1 width=2,458) (actual time=5.451..5.451 rows=0 loops=1)

  • Join Filter: (dataset_1.id = start.id)
5. 0.978 0.978 ↑ 1.0 1 1

Index Scan using dataset_1_pkey on dataset_1 (cost=0.43..8.48 rows=1 width=2,458) (actual time=0.977..0.978 rows=1 loops=1)

  • Index Cond: (id = 10548586)
  • Filter: ((lower(activity_state) = 'inactive'::text) AND ((concrete_id = 87) OR (concrete_id = 89) OR (concrete_id = 619) OR (concrete_id = 95) OR
6. 0.002 4.467 ↑ 2.0 1 1

Nested Loop (cost=0.87..211,569.79 rows=2 width=4) (actual time=4.467..4.467 rows=1 loops=1)

7. 0.029 0.029 ↑ 1.0 1 1

Index Only Scan using dataset_1_pkey on dataset_1 start (cost=0.43..8.45 rows=1 width=4) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: (id = 10548586)
  • Heap Fetches: 1
8. 4.436 4.436 ↑ 2.0 1 1

Index Scan using index_on_24_on_dataset_5 on dataset_5 ds1_0 (cost=0.43..211,561.32 rows=2 width=4) (actual time=4.436..4.436 rows=1 loops=1)

  • Index Cond: (lower(activity_state) = 'inactive'::text)
  • Filter: (_alert = 10548586)
  • Rows Removed by Filter: 625