explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sqwC

Settings
# exclusive inclusive rows x rows loops node
1. 1.243 717,633.007 ↓ 131.0 3,143 1

Unique (cost=5,746,649.93..5,746,650.05 rows=24 width=4) (actual time=716,789.663..717,633.007 rows=3,143 loops=1)

  • Functions: 31
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 5.993 ms, Inlining 229.492 ms, Optimization 387.065 ms, Emission 214.117 ms, Total 836.666 ms
2. 8.482 717,631.764 ↓ 310.6 7,454 1

Sort (cost=5,746,649.93..5,746,649.99 rows=24 width=4) (actual time=716,789.660..717,631.764 rows=7,454 loops=1)

  • Sort Key: lc.id
  • Sort Method: quicksort Memory: 542kB
3. 891.219 717,623.282 ↓ 310.6 7,454 1

Gather (cost=1,000.43..5,746,649.38 rows=24 width=4) (actual time=7,570.353..717,623.282 rows=7,454 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 16.803 716,732.063 ↓ 248.5 2,485 3 / 3

Nested Loop (cost=0.43..5,745,646.98 rows=10 width=4) (actual time=4,034.705..716,732.063 rows=2,485 loops=3)

5. 715,444.404 715,444.404 ↓ 2.1 4,742 3 / 3

Parallel Seq Scan on lex_docket_entry lde (cost=0.00..5,729,635.50 rows=2,223 width=8) (actual time=4,023.341..715,444.404 rows=4,742 loops=3)

  • Filter: ((info ->> 'Description'::text) ~~* '%garnishment%'::text)
  • Rows Removed by Filter: 14,831,445
6. 1,270.856 1,270.856 ↑ 1.0 1 14,226 / 3

Index Scan using lex_case_pkey on lex_case lc (cost=0.43..7.19 rows=1 width=8) (actual time=0.268..0.268 rows=1 loops=14,226)

  • Index Cond: (id = lde.case_id)
  • Filter: ((court_id = 121) AND (lde.filed_on >= filed_on) AND (lde.filed_on <= (filed_on + '14 days'::interval)))
  • Rows Removed by Filter: 0
Planning time : 4.895 ms
Execution time : 717,637.568 ms