explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZWOK

Settings
# exclusive inclusive rows x rows loops node
1. 4,653.233 66,291.324 ↓ 2,329.0 2,329 1

Nested Loop (cost=13.74..35.60 rows=1 width=84) (actual time=244.593..66,291.324 rows=2,329 loops=1)

2. 74.010 2,878.515 ↓ 13,276.0 13,276 1

Nested Loop (cost=13.30..21.33 rows=1 width=788) (actual time=230.573..2,878.515 rows=13,276 loops=1)

3. 61.700 278.205 ↓ 24,060.0 24,060 1

HashAggregate (cost=12.88..12.89 rows=1 width=8) (actual time=228.958..278.205 rows=24,060 loops=1)

  • Group Key: positive_lex_case_tags.lex_case_id
4. 216.505 216.505 ↓ 24,113.0 24,113 1

Index Scan using ix_positive_lex_case_tags_tag_id on positive_lex_case_tags (cost=0.42..12.88 rows=1 width=8) (actual time=2.697..216.505 rows=24,113 loops=1)

  • Index Cond: (tag_id = ANY ('{17,490}'::integer[]))
5. 2,526.300 2,526.300 ↑ 1.0 1 24,060

Index Scan using lex_case_pkey on lex_case c (cost=0.42..8.45 rows=1 width=780) (actual time=0.105..0.105 rows=1 loops=24,060)

  • Index Cond: (id = positive_lex_case_tags.lex_case_id)
  • Filter: (court_id = 118)
  • Rows Removed by Filter: 0
6. 58,759.576 58,759.576 ↓ 0.0 0 13,276

Index Scan using ix_lex_document_case_id on lex_document doc (cost=0.43..14.25 rows=1 width=52) (actual time=4.016..4.426 rows=0 loops=13,276)

  • Index Cond: (case_id = c.id)
  • Filter: (title ~~* 'Memo%Costs%'::text)
  • Rows Removed by Filter: 34
Planning time : 3.034 ms
Execution time : 66,293.141 ms