explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BsX57

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.623 ↓ 0.0 0 1

Nested Loop (cost=4.18..8.19 rows=1 width=8) (actual time=0.623..0.623 rows=0 loops=1)

2. 0.001 0.623 ↓ 0.0 0 1

Limit (cost=4.10..4.10 rows=1 width=12) (actual time=0.623..0.623 rows=0 loops=1)

3. 0.040 0.622 ↓ 0.0 0 1

Sort (cost=4.10..4.10 rows=1 width=12) (actual time=0.622..0.622 rows=0 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.001 0.582 ↓ 0.0 0 1

GroupAggregate (cost=4.09..4.10 rows=1 width=12) (actual time=0.582..0.582 rows=0 loops=1)

  • Group Key: journal_identifiers.journal_id
5. 0.016 0.581 ↓ 0.0 0 1

Sort (cost=4.09..4.09 rows=1 width=4) (actual time=0.581..0.581 rows=0 loops=1)

  • Sort Key: journal_identifiers.journal_id
  • Sort Method: quicksort Memory: 25kB
6. 0.565 0.565 ↓ 0.0 0 1

Index Scan using journal_ids_id_value_btree on journal_identifiers (cost=0.08..4.09 rows=1 width=4) (actual time=0.565..0.565 rows=0 loops=1)

  • Index Cond: ((identifier_value)::text = '1553-7390'::text)
  • Filter: (journal_id IS NOT NULL)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using journals_pkey on journals j2 (cost=0.09..4.09 rows=1 width=8) (never executed)

  • Index Cond: (id = journal_identifiers.journal_id)
Planning time : 1.949 ms
Execution time : 0.711 ms