explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lZBs

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.088 ↑ 11.9 7 1

Nested Loop (cost=1.14..932.08 rows=83 width=22) (actual time=0.021..0.088 rows=7 loops=1)

2. 0.004 0.064 ↑ 12.4 7 1

Nested Loop (cost=0.87..905.75 rows=87 width=4) (actual time=0.018..0.064 rows=7 loops=1)

3. 0.018 0.018 ↑ 12.4 7 1

Index Scan using "iSvyazDokumentov-DokumentSledstvie" on "СвязьДокументов" sv (cost=0.43..169.30 rows=87 width=4) (actual time=0.011..0.018 rows=7 loops=1)

  • Index Cond: ("ДокументСледствие" = 44680840)
4. 0.042 0.042 ↑ 1.0 1 7

Index Scan using "pДокумент" on "Документ" doc (cost=0.43..8.46 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=7)

  • Index Cond: ("@Документ" = sv."ДокументОснование")
5. 0.021 0.021 ↑ 1.0 1 7

Index Scan using "pТипДокумента" on "ТипДокумента" doct (cost=0.27..0.29 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=7)

  • Index Cond: ("@ТипДокумента" = doc."ТипДокумента")
Planning time : 0.805 ms
Execution time : 0.135 ms