explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jvxK

Settings
# exclusive inclusive rows x rows loops node
1. 304.101 123,644.521 ↑ 1.1 240,518 1

Gather (cost=1,674,067.80..5,491,053.48 rows=266,506 width=4) (actual time=40,257.492..123,644.521 rows=240,518 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 69
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 11.491 ms, Inlining 412.389 ms, Optimization 456.192 ms, Emission 365.496 ms, Total 1245.568 ms
2. 317.149 123,340.420 ↑ 1.4 80,173 3 / 3

Parallel Hash Join (cost=1,673,067.80..5,463,402.88 rows=111,044 width=4) (actual time=40,207.482..123,340.420 rows=80,173 loops=3)

  • Hash Cond: (lex_document.case_id = lex_case.id)
3. 6,442.749 121,733.502 ↓ 1.0 337,655 3 / 3

Parallel Hash Join (cost=1,403,871.11..5,193,352.47 rows=325,229 width=8) (actual time=38,912.970..121,733.502 rows=337,655 loops=3)

  • Hash Cond: (lex_document.docket_entry_id = lex_docket_entry.id)
4. 76,385.167 76,385.167 ↑ 1.2 10,168,224 3 / 3

Parallel Seq Scan on lex_document (cost=0.00..3,740,581.71 rows=12,682,771 width=16) (actual time=0.925..76,385.167 rows=10,168,224 loops=3)

5. 343.170 38,905.586 ↑ 1.2 401,081 3 / 3

Parallel Hash (cost=1,397,981.70..1,397,981.70 rows=471,153 width=16) (actual time=38,905.581..38,905.586 rows=401,081 loops=3)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 72,896kB
6. 238.094 38,562.416 ↑ 1.2 401,081 3 / 3

Nested Loop (cost=0.56..1,397,981.70 rows=471,153 width=16) (actual time=2.823..38,562.416 rows=401,081 loops=3)

7. 1,023.820 1,023.820 ↑ 1.2 401,081 3 / 3

Parallel Seq Scan on positive_lex_docket_entry_tags (cost=0.00..65,115.82 rows=471,153 width=8) (actual time=1.105..1,023.820 rows=401,081 loops=3)

  • Filter: (tag_id = 15)
  • Rows Removed by Filter: 1,559,717
8. 37,300.502 37,300.502 ↑ 1.0 1 1,203,242 / 3

Index Only Scan using lex_docket_entry_pkey on lex_docket_entry (cost=0.56..2.83 rows=1 width=8) (actual time=0.093..0.093 rows=1 loops=1,203,242)

  • Index Cond: (id = positive_lex_docket_entry_tags.lex_docket_entry_id)
  • Heap Fetches: 0
9. 128.764 1,289.769 ↑ 1.3 249,622 3 / 3

Parallel Hash (cost=265,287.71..265,287.71 rows=312,718 width=4) (actual time=1,289.767..1,289.769 rows=249,622 loops=3)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 37,536kB
10. 1,161.005 1,161.005 ↑ 1.3 249,622 3 / 3

Parallel Seq Scan on lex_case (cost=0.00..265,287.71 rows=312,718 width=4) (actual time=412.134..1,161.005 rows=249,622 loops=3)

  • Filter: (court_id = 118)
  • Rows Removed by Filter: 483,102
Planning time : 213.966 ms
Execution time : 123,759.067 ms